NAME

       v.db.select  - Prints vector map attributes.

KEYWORDS

       vector, database, attribute table

SYNOPSIS

       v.db.select
       v.db.select help
       v.db.select    [-rcv]    map=name     [layer=integer]     [columns=name[,name,...]]     [where=sql_query]
       [fs=character]   [vs=character]   [nv=string]   [file=name]   [--verbose]  [--quiet]

   Flags:
       -r
           Print minimal region extent of selected vector features instead of attributes

       -c
           Do not include column names in output

       -v
           Vertical output (instead of horizontal)

       --verbose
           Verbose module output

       --quiet
           Quiet module output

   Parameters:
       map=name
           Name of input vector map

       layer=integer
           Layer number
           A single vector map can be connected to multiple database tables. This number determines which  table
           to use.
           Default: 1

       columns=name[,name,...]
           Name of attribute column(s)

       where=sql_query
           WHERE conditions of SQL statement without 'where' keyword
           Example: income = 10000

       fs=character
           Field separator
           Output field separator
           Default: |

       vs=character
           Field separator
           Output vertical record separator

       nv=string
           Null value indicator

       file=name
           Name for output file (if omitted or "-" output to stdout)

DESCRIPTION

       v.db.select prints attributes of a vector map from one or several user selected attribute table columns.

EXAMPLES

       Select and show entire table:
       v.db.select map=roads
       cat|label
       0|no data
       1|interstate
       2|primary highway, hard surface
       3|secondary highway, hard surface
       4|light-duty road, improved surface
       5|unimproved road
        Select and show single column from table (multiple columns can be specified as comma separated list):
       v.db.select map=roads column=label
       label
       no data
       interstate
       primary highway, hard surface
       secondary highway, hard surface
       light-duty road, improved surface
       unimproved road
        Print region extent of selected vector features:
       v.db.select -r map=roads where="label ~ 'highway'"
       n=4928063.398015
       s=4914089.153930
       w=589532.054964
       e=609527.210215

SEE ALSO

       db.select

AUTHOR

       Radim Blazek, ITC-Irst, Trento, Italy
       Minimal region extent added by Martin Landa, FBK-irst (formerly ITC-irst), Trento, Italy (2008/08)

       Last changed: $Date: 2011-11-08 01:42:51 -0800 (Tue, 08 Nov 2011) $

       Full index

       © 2003-2013 GRASS Development Team

GRASS 6.4.3                                                                                  v.db.select(1grass)