db.columns - GRASS GIS manual

Note: This document is for an older version of GRASS GIS that will be discontinued soon. You should upgrade, and read the current manual page.

NAME

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

db.columns

db.columns --help

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

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

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

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.

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

db.columns table=zipcodes_wake driver=dbf database=/grassdata/nc_spm_08/PERMANENT/dbf/

Note that the SQLite backend is the default setting.

db.columns driver=sqlite table=archsites database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db'

Radim Blazek, ITC-Irst, Trento, Italy

Latest change: Mon Nov 18 20:15:32 2019 in commit: 1a1d107e4f6e1b846f9841c2c6fabf015c5f720d

Note: This document is for an older version of GRASS GIS that will be discontinued soon. You should upgrade, and read the current manual page.