1v.db.addcol(1) Grass User's Manual v.db.addcol(1)
2
3
4
6 v.db.addcol - Adds one or more columns to the attribute table con‐
7 nected to a given vector map
8
10 vector, database, attribute table
11
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
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
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
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
55 db.execute, v.db.addtable, v.db.connect, v.db.droptable, v.db.select,
56 v.db.update
57
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)