Rechercher une page de manuel
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, SQLSYNOPSIS
db.selectdb.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.tablesAUTHOR
?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
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre