db.columns1grass
List all columns for a given table.
Usage
db.columns
db.columns --help
db.columns table=name
[driver=name]
[database=name]
[--help]
[--verbose]
[--quiet]
[--ui]
Keywords
database, attribute table
Overview
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=grassdbIf the database parameters are already set, the columns can be listed directly
db.columns table=zipcodes_wakeList 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’Source code
Available at: db.columns source code (history)
Accessed: Monday Feb 24 17:50:22 2025
Main index | Database index | Topics index | Keywords index | Graphical index | Full index
© 2003-2025 GRASS Development Team, GRASS GIS 8.4.1 Reference Manual
Releases
10 releases since Debian 4.0 (Etch); the text changed 9 times.