This is the command db.columnsgrass that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator
PROGRAM:
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=name [required]
Name of attribute table
driver=name
Name of database driver
Options: mysql, odbc, sqlite, pg, ogr, dbf
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’
Use db.columnsgrass online using onworks.net services