This is the command db.describegrass 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.describe - Describes a table in detail.
KEYWORDS
database, attribute table
SYNOPSIS
db.describe
db.describe --help
db.describe [-ct] table=name [driver=name] [database=name] [--help] [--verbose]
[--quiet] [--ui]
Flags:
-c
Print column names only instead of full column descriptions
-t
Print table structure
--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.describe displays table information. If parameter -c is used only column names instead
of full column descriptions is given.
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 column descriptions of table in SQLite database (note that this is the default
setting)
db.describe driver=sqlite table=hospitals \
database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’
# or simply
db.describe myarchsites
DBF example
db.describe -c table=hospitals database=’$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/’ \
driver=dbf
ncols: 16
nrows: 160
Column 1: cat:INTEGER:11
Column 2: OBJECTID:INTEGER:11
Column 3: AREA:DOUBLE PRECISION:20
[...]
db.describe table=hospitals database=’$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/’ \
driver=dbf
table:hospitals
description:
insert:yes
delete:yes
ncols:16
nrows:160
column:cat
description:
type:INTEGER
len:11
scale:0
precision:10
default:
nullok:yes
select:yes
update:yes
column:OBJECTID
description:
type:INTEGER
[...]
Use db.describegrass online using onworks.net services