NAME

       v.db.addcol  - Adds one or more columns to the attribute table connected to a given vector map.

KEYWORDS

       vector, database, attribute table

SYNOPSIS

       v.db.addcol
       v.db.addcol help
       v.db.addcol map=name  [layer=integer]  columns=string  [--verbose]  [--quiet]

   Parameters:
       map=name
           Name of vector map for which to edit attribute table

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

       columns=string
           Name and type of the new column(s) ('name type [,name type, ...]')
           Data types depend on database backend, but all support VARCHAR(), INT, DOUBLE PRECISION and DATE

DESCRIPTION

       v.db.addcol adds one or more column(s) to the attribute  table  connected  to  a  given  vector  map.  It
       automatically checks the connection for the specified layer.

NOTES

       v.db.addcol is a front-end to db.execute to allow easier usage.  The supported types of columns depend on
       the  database  backend. However, all backends should support VARCHAR, INT, DOUBLE PRECISION and DATE. The
       default dbf backend supports only these types.  The existing database connection(s) can be verified  with
       v.db.connect.

EXAMPLES

       Adding a single column:

       v.db.addcol sentiero_brenta_points columns="slope double precision"
       v.info -c sentiero_brenta_points

       Adding two columns:

       v.db.addcol sentiero_brenta_points columns="slope double precision,myname varchar(15)"
       v.info -c sentiero_brenta_points

SEE ALSO

       db.execute, v.db.addtable, v.db.connect, v.db.dropcol, v.db.droptable, v.db.select, v.db.update,
       GRASS SQL interface

AUTHOR

       Moritz Lennert (mlennert@club.worldonline.be)

       Last changed: $Date: 2010-03-21 09:19:18 -0800 (Sun, 21 Mar 2010) $

       Full index

       © 2003-2013 GRASS Development Team

GRASS 6.4.3                                                                                  v.db.addcol(1grass)