.TH v.db.select 1grass "" "GRASS 6.4.4" "Grass User's Manual"
.SH NAME
\fI\fBv.db.select\fR\fR  - Prints vector map attributes.
.SH KEYWORDS
vector, database, attribute table
.SH SYNOPSIS
\fBv.db.select\fR
.br
\fBv.db.select help\fR
.br
\fBv.db.select\fR [\-\fBrcv\fR] \fBmap\fR=\fIname\fR  [\fBlayer\fR=\fIinteger\fR]   [\fBcolumns\fR=\fIname\fR[,\fIname\fR,...]]   [\fBwhere\fR=\fIsql_query\fR]   [\fBfs\fR=\fIcharacter\fR]   [\fBvs\fR=\fIcharacter\fR]   [\fBnv\fR=\fIstring\fR]   [\fBfile\fR=\fIname\fR]   [\-\-\fBverbose\fR]  [\-\-\fBquiet\fR] 
.SS Flags:
.IP "\fB\-r\fR" 4m
.br
Print minimal region extent of selected vector features instead of attributes
.IP "\fB\-c\fR" 4m
.br
Do not include column names in output
.IP "\fB\-v\fR" 4m
.br
Vertical output (instead of horizontal)
.IP "\fB\-\-verbose\fR" 4m
.br
Verbose module output
.IP "\fB\-\-quiet\fR" 4m
.br
Quiet module output
.PP
.SS Parameters:
.IP "\fBmap\fR=\fIname\fR" 4m
.br
Name of input vector map
.IP "\fBlayer\fR=\fIinteger\fR" 4m
.br
Layer number
.br
A single vector map can be connected to multiple database tables. This number determines which table to use.
.br
Default: \fI1\fR
.IP "\fBcolumns\fR=\fIname[,\fIname\fR,...]\fR" 4m
.br
Name of attribute column(s)
.IP "\fBwhere\fR=\fIsql_query\fR" 4m
.br
WHERE conditions of SQL statement without 'where' keyword
.br
Example: income = 10000
.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 "\fBfile\fR=\fIname\fR" 4m
.br
Name for output file (if omitted or "-" output to stdout)
.PP
.SH DESCRIPTION
\fIv.db.select\fR prints attributes of a vector map from one or several
user selected attribute table columns.
.SH EXAMPLES
Select and show entire table:
\fC
.DS
.br
v.db.select map=roads
.br
cat|label
.br
0|no data
.br
1|interstate
.br
2|primary highway, hard surface
.br
3|secondary highway, hard surface
.br
4|light-duty road, improved surface
.br
5|unimproved road
.br
.DE
\fR
Select and show single column from table (multiple columns can be
specified as comma separated list):
\fC
.DS
.br
v.db.select map=roads column=label
.br
label
.br
no data
.br
interstate
.br
primary highway, hard surface
.br
secondary highway, hard surface
.br
light-duty road, improved surface
.br
unimproved road
.br
.DE
\fR
Print region extent of selected vector features:
\fC
.DS
.br
v.db.select \-r map=roads where="label ~ 'highway'"
.br
n=4928063.398015
.br
s=4914089.153930
.br
w=589532.054964
.br
e=609527.210215
.br
.DE
\fR
.SH SEE ALSO
\fIdb.select\fR
.SH AUTHOR
Radim Blazek, ITC-Irst, Trento, Italy
.br
Minimal region extent added by Martin Landa,
FBK-irst (formerly ITC-irst), Trento, Italy (2008/08)
.PP
\fILast changed: $Date: 2011-11-08 10:42:51 +0100 (Tue, 08 Nov 2011) $\fR
.PP
Full index
.PP
© 2003-2014 GRASS Development Team