db.select.1grass

Langue: en

Version: 333299 (ubuntu - 24/10/10)

Section: 1 (Commandes utilisateur)

NAME

db.select - Selects data from table.

KEYWORDS

database, attribute table, SQL

SYNOPSIS

db.select
db.select help
db.select [-cdvt] [table=name] [database=name] [driver=name] [sql=string] [input=name] [fs=character] [vs=character] [nv=string] [--verbose] [--quiet]

Flags:

-c

Do not include column names in output
-d

Describe query only (don't run it)
-v

Vertical output (instead of horizontal)
-t

Only test query, do not execute
--verbose

Verbose module output
--quiet

Quiet module output

Parameters:

table=name

Table name
database=name

Database name
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
driver=name

Driver name
Options: dbf,odbc,pg,mysql,sqlite,ogr
Default: dbf
sql=string

SQL select statement
For example: 'select * from rybniky where kapri = 'hodne'
input=name

Name of file with sql statement
fs=character

Output field separator
Default: |
vs=character

Output vertical record separator
nv=string

Null value indicator

DESCRIPTION

db.select prints result of selection from database based on SQL statement read from input file or from standard input to standard output.

NOTE

If parameters for database connection are already set with db.connect, they are taken as default values and do not need to be spcified each time. Output will be displayed to stdout or can be directed to a file.

EXAMPLES


echo "select * from roads" | db.select
or

 cat file.sql | db.select 
or

 db.select input=file.sql

Select all from table roads

db.select -c driver=odbc database=g51test table=roads input=file.sql > result.csv

Select some string attribute, exclude others:

echo "SELECT * FROM archsites WHERE str1 <> 'No Name'" | db.select

Select some string attribute with ZERO length:

echo "SELECT * FROM archsites WHERE str1 IS NULL" | db.select

Select coordinates from PostGIS table:

echo "SELECT x(geo),y(geo) FROM localizzazione" | db.select

SEE ALSO

GRASS SQL interface, db.connect, db.describe, db.drivers, db.droptable, db.execute, db.login, db.tables

AUTHOR

?
Modifications: Radim Blazek, ITC-Irst, Trento, Italy

Last changed: $Date: 2006-09-21 06:31:01 +0200 (gio, 21 set 2006) $

Full index

© 2003-2010 GRASS Development Team