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

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

SEE ALSO

GRASS 5.1 tutorial pages, db.connect

AUTHOR

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

Help Index