GRASS logo

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

Parameters:

map=name
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 PRECISION/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.

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.droptable, v.db.select, v.db.update

AUTHOR

Moritz Lennert (mlennert@club.worldonline.be)

Last changed: $Date: 2005/11/15 08:47:49 $


Main index - vector index - Full index