NAME
db.columns - List all columns for a given table.KEYWORDS
database, attribute tableSYNOPSIS
db.columns
db.columns --helpdb.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=name [required]
- Name of attribute table
- driver=name
- Name of database driver
- Options: dbf, odbc, ogr, pg, sqlite
- Default: sqlite
- database=name
- Name of database
- Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db
Table of contents
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.login, db.tables, GRASS SQL interfaceAUTHOR
Radim Blazek, ITC-Irst, Trento, ItalySOURCE CODE
Available at: db.columns source code (history)
Latest change: Thu Feb 3 11:10:06 2022 in commit: 73413160a81ed43e7a5ca0dc16f0b56e450e9fef
Main index | Database index | Topics index | Keywords index | Graphical index | Full index
© 2003-2022 GRASS Development Team, GRASS GIS 8.0.3dev Reference Manual