NAME
v.db.addcol - adds a column to the attribute table connected to a given vector map
SYNOPSIS
v.db.addcol
v.db.addcol help
v.db.addcol map=string [layer=integer] columns=string
Parameters:
- map=string
- vector map for which to edit attribute table
- layer=integer
- Layer where to add column
- Default: 1
- columns=string
- name and type of the new column(s) (types depend on database backend, but all support VARCHAR, INT, DOUBLE/REAL 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/REAL and DATE. The default dbf backend
supports only these types.
The existing database connection(s) can be verified with v.db.connect.
EXAMPLE
Adding a single column:
v.db.addcol sentiero_brenta_points columns="slope double"
v.info -c sentiero_brenta_points
Adding two columns:
v.db.addcol sentiero_brenta_points columns="slope double,myname varchar(15)"
v.info -c sentiero_brenta_points
SEE ALSO
db.execute,
v.db.addtable,
v.db.connect,
v.db.droptable,
v.db.select,
v.db.update
AUTHOR
Moritz Lennert (mlennert@club.worldonline.be)
Last changed: $Date: 2005/09/09 15:54:20 $
Main index - vector index - Full index