1v.db.addcol(1)                Grass User's Manual               v.db.addcol(1)
2
3
4

NAME

6       v.db.addcol   -  Adds  one  or more columns to the attribute table con‐
7       nected to a given vector map.
8

KEYWORDS

10       vector, database, attribute table
11

SYNOPSIS

13       v.db.addcol
14       v.db.addcol help
15       v.db.addcol  map=name   [layer=integer]   columns=string    [--verbose]
16       [--quiet]
17
18   Parameters:
19       map=name
20           Vector map for which to edit attribute table
21
22       layer=integer
23           Layer where to add column
24           Default: 1
25
26       columns=string
27           Name  and type of the new column(s) (types depend on database back‐
28           end, but all support VARCHAR(), INT, DOUBLE and DATE)
29

DESCRIPTION

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

NOTES

36       v.db.addcol is a front-end to db.execute to allow  easier  usage.   The
37       supported types of columns depend on the database backend. However, all
38       backends should support VARCHAR, INT, DOUBLE/REAL and DATE. The default
39       dbf  backend  supports only these types.  The existing database connec‐
40       tion(s) can be verified with v.db.connect.
41

EXAMPLES

43       Adding a single column:
44
45       v.db.addcol sentiero_brenta_points columns="slope double precision"
46       v.info -c sentiero_brenta_points
47
48
49       Adding two columns:
50
51       v.db.addcol   sentiero_brenta_points   columns="slope   double   preci‐
52       sion,myname varchar(15)"
53       v.info -c sentiero_brenta_points
54
55

SEE ALSO

57       db.execute,  v.db.addtable, v.db.connect, v.db.dropcol, v.db.droptable,
58       v.db.select, v.db.update
59

AUTHOR

61       Moritz Lennert (mlennert@club.worldonline.be)
62
63       Last changed: $Date: 2007-02-05 15:33:02 +0100 (Mon, 05 Feb 2007) $
64
65       Full index
66
67       © 2003-2008 GRASS Development Team
68
69
70
71GRASS 6.3.0                                                     v.db.addcol(1)