Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
v.db.addcolumn(1)	    GRASS GIS User's Manual	     v.db.addcolumn(1)

NAME
       v.db.addcolumn	- Adds one or more columns to the attribute table con-
       nected to a given vector	map.

KEYWORDS
       vector, attribute table,	database

SYNOPSIS
       v.db.addcolumn
       v.db.addcolumn --help
       v.db.addcolumn  map=name	   [layer=string]    columns=name   type[,name
       type,...]  [--help]  [--verbose]	 [--quiet]  [--ui]

   Flags:
       --help
	   Print usage summary

       --verbose
	   Verbose module output

       --quiet
	   Quiet module	output

       --ui
	   Force launching GUI dialog

   Parameters:
       map=nameA [required]
	   Name	of vector map
	   Or data source for direct OGR access

       layer=string
	   Layer number	where to add column(s)
	   Vector  features can	have category values in	different layers. This
	   number determines which layer to use. When used with	direct OGR ac-
	   cess	this is	the layer name.
	   Default: 1

       columns=name type[,name type,...]A [required]
	   Name	and type of the	new column(s) ('name type [,name type, ...]')
	   Types  depend  on database backend, but all support VARCHAR(), INT,
	   DOUBLE PRECISION and	DATE. Example: 'label varchar(250), value  in-
	   teger'

DESCRIPTION
       v.db.addcolumn  adds  one or more column(s) to the attribute table con-
       nected to a given vector	map. It	automatically  checks  the  connection
       for the specified layer.

NOTES
       v.db.addcolumn 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 PRECISION and DATE.

       The existing database connection(s) can be verified with	v.db.connect.

EXAMPLES
       Adding a	single column:
       g.copy vect=roadsmajor,myroads
       v.db.addcolumn myroads columns="slope double precision"
       v.info -c myroads

       Adding two columns:
       g.copy vect=roadsmajor,myroads
       v.db.addcolumn myroads columns="slope double precision,myname varchar(15)"
       v.info -c myroads

SEE ALSO
	 db.connect, db.execute, v.db.addtable,	v.db.connect, v.db.dropcolumn,
       v.db.droptable, v.db.select, v.db.update
       GRASS SQL interface

AUTHOR
       Moritz Lennert (mlennert@club.worldonline.be)

SOURCE CODE
       Available at: v.db.addcolumn source code	(history)

       Main index | Vector index | Topics index	| Keywords index  |  Graphical
       index | Full index

       A(C) 2003-2020 GRASS Development	Team, GRASS GIS	7.8.3 Reference	Manual

GRASS 7.8.3						     v.db.addcolumn(1)

NAME | KEYWORDS | SYNOPSIS | DESCRIPTION | NOTES | EXAMPLES | SEE ALSO | AUTHOR | SOURCE CODE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=v.db.addcolumn&sektion=1&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help