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

FreeBSD Manual Pages

  
 
  

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

NAME
       db.columns  - List all columns for a given table.

KEYWORDS
       database, attribute table

SYNOPSIS
       db.columns
       db.columns --help
       db.columns   table=name	  [driver=name]	   [database=name]    [--help]
       [--verbose]  [--quiet]  [--ui]

   Flags:
       --help
	   Print usage summary

       --verbose
	   Verbose module output

       --quiet
	   Quiet module	output

       --ui
	   Force launching GUI dialog

   Parameters:
       table=nameA [required]
	   Name	of attribute table

       driver=name
	   Name	of database driver
	   Options: dbf, ogr, pg, sqlite
	   Default: sqlite

       database=name
	   Name	of database
	   Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db

DESCRIPTION
       db.columns lists	all columns for	a give table. Connection to  databases
       are supported through dbf, shp, odbc and	pg drivers.

NOTE
       If  parameters for database connection are already set with db.connect,
       they are	taken as default values	and do not need	to  be	spcified  each
       time.

EXAMPLES
   List	columns	of a PostgreSQL	attribute table
       db.columns table=zipcodes_wake driver=pg	database=grassdb

       If  the	database parameters are	already	set, the columns can be	listed
       directly
       db.columns table=zipcodes_wake

   List	columns	from Shape file	with DBF attribute table
       db.columns table=zipcodes_wake driver=dbf database=/grassdata/nc_spm_08/PERMANENT/dbf/

   List	columns	of table in SQLite database
       Note that the SQLite backend is the default setting.
       db.columns driver=sqlite	table=archsites	database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db'

SEE ALSO
	db.connect, db.describe, db.drivers, db.droptable, db.execute,	db.lo-
       gin, db.tables, GRASS SQL interface

       GRASS SQL interface

AUTHOR
       Radim Blazek, ITC-Irst, Trento, Italy

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

       Main index | Database index | Topics index | Keywords index | Graphical
       index | Full index

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

GRASS 7.8.4							 db.columns(1)

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

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

home | help