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
16
17   Parameters:
18       map=name
19           Vector map for which to edit attribute table
20
21       layer=integer
22           Layer where to add column Default: 1
23
24       columns=string
25           Name and type of the new column(s) (types depend on database  back‐
26           end, but all support VARCHAR, INT, DOUBLE PRECISION/REAL and DATE)
27

DESCRIPTION

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

NOTES

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

EXAMPLES

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

SEE ALSO

55       db.execute, v.db.addtable, v.db.connect,  v.db.droptable,  v.db.select,
56       v.db.update
57

AUTHOR

59       Moritz Lennert (mlennert@club.worldonline.be)
60
61       Last changed: $Date: 2005/11/15 08:47:49 $
62
63       Full index
64
65
66
67GRASS 6.2.2                                                     v.db.addcol(1)