.TH db.select 1grass "" "GRASS 6.4.4" "Grass User's Manual"
.SH NAME
\fI\fBdb.select\fR\fR  - Selects data from attribute table (performs SQL query statement(s)).
.SH KEYWORDS
database, attribute table, SQL
.SH SYNOPSIS
\fBdb.select\fR
.br
\fBdb.select help\fR
.br
\fBdb.select\fR [\-\fBcdvt\fR]  [\fBtable\fR=\fIname\fR]   [\fBdatabase\fR=\fIname\fR]   [\fBdriver\fR=\fIname\fR]   [\fBsql\fR=\fIstring\fR]   [\fBinput\fR=\fIname\fR]   [\fBfs\fR=\fIcharacter\fR]   [\fBvs\fR=\fIcharacter\fR]   [\fBnv\fR=\fIstring\fR]   [\fBoutput\fR=\fIname\fR]   [\-\-\fBverbose\fR]  [\-\-\fBquiet\fR] 
.SS Flags:
.IP "\fB\-c\fR" 4m
.br
Do not include column names in output
.IP "\fB\-d\fR" 4m
.br
Describe query only (don't run it)
.IP "\fB\-v\fR" 4m
.br
Vertical output (instead of horizontal)
.IP "\fB\-t\fR" 4m
.br
Only test query, do not execute
.IP "\fB\-\-verbose\fR" 4m
.br
Verbose module output
.IP "\fB\-\-quiet\fR" 4m
.br
Quiet module output
.PP
.SS Parameters:
.IP "\fBtable\fR=\fIname\fR" 4m
.br
Table name
.IP "\fBdatabase\fR=\fIname\fR" 4m
.br
Database name
.br
Default: \fI$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/\fR
.IP "\fBdriver\fR=\fIname\fR" 4m
.br
Driver name
.br
Options: \fIpg,dbf,ogr,odbc,mysql,sqlite\fR
.br
Default: \fIdbf\fR
.IP "\fBsql\fR=\fIstring\fR" 4m
.br
SQL select statement
.br
For example: 'select * from rybniky where kapri = 'hodne'
.IP "\fBinput\fR=\fIname\fR" 4m
.br
Name of file with sql statement
.IP "\fBfs\fR=\fIcharacter\fR" 4m
.br
Field separator
.br
Output field separator
.br
Default: \fI|\fR
.IP "\fBvs\fR=\fIcharacter\fR" 4m
.br
Field separator
.br
Output vertical record separator
.IP "\fBnv\fR=\fIstring\fR" 4m
.br
Null value indicator
.IP "\fBoutput\fR=\fIname\fR" 4m
.br
Name for output file (if omitted or "-" output to stdout)
.PP
.SH DESCRIPTION
\fIdb.select\fR prints result of selection from database 
based on SQL statement read from input file or from standard input 
to standard output.
.SH 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.
.SH EXAMPLES
\fC
.DS
.br
echo "select * from roads" | db.select 
.br
or
.br
 cat file.sql | db.select 
.br
or
.br
 db.select input=file.sql
.br
.DE
\fR
.PP
\fISelect all from table roads\fR
.br
\fC
.DS
.br
db.select \-c driver=odbc database=mydb table=roads \(rs
.br
          input=file.sql output=result.csv
.br
.DE
\fR
.PP
\fISelect some string attribute, exclude others:\fR
.br
\fC
.DS
.br
echo "SELECT * FROM archsites WHERE str1 <> 'No Name'" | db.select
.br
.DE
\fR
.PP
\fISelect some string attribute with ZERO length:\fR
.br
\fC
.DS
.br
echo "SELECT * FROM archsites WHERE str1 IS NULL" | db.select
.br
.DE
\fR
.PP
\fISelect coordinates from PostGIS table:\fR
.br
\fC
.DS
.br
echo "SELECT x(geo),y(geo) FROM localizzazione" | db.select
.br
.DE
\fR
.PP
\fICount number of cases falling into same position:\fR
.br
When multiple observation have the spatial coordinates, they can still be counted
(if needed, coordinates can be uploaded to the attribute table by \fIv.to.db\fR:
\fC
.DS 
.br
db.select sql="SELECT long,lat,site_id,department,obs,COUNT(long) as count_cases \(rs
.br
               FROM diseases GROUP BY long,lat"
.br
.DE
\fR
.SH SEE ALSO
\fI
GRASS SQL interface,
.br
db.connect,
db.describe,
db.drivers,
db.droptable,
db.execute,
db.login,
db.tables\fR
.SH AUTHOR
Unknown
.br
Modifications: Radim Blazek, ITC-Irst, Trento, Italy
.PP
\fILast changed: $Date: 2013-04-09 18:52:11 +0200 (Tue, 09 Apr 2013) $\fR
.PP
Full index
.PP
© 2003-2014 GRASS Development Team