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