Flags:¶

-e

Print type information about the columns
Print the name and the type of all the columns for a given table.

--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, mysql, odbc, ogr, pg, sqlite
Default: sqlite

database=name

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

separator=character

Field separator
Special characters: pipe, comma, space, tab, newline

format=name [required]

Output format
Options: plain, csv, json, list
Default: plain
plain: Configurable plain text output
csv: CSV (Comma Separated Values)
json: JSON (JavaScript Object Notation)
list: Output in list format

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’