NAME

db.describe - Describe a table (in detail).

SYNOPSIS

db.describe
db.describe help
db.describe [-c] table=string [driver=string] [database=string]

Flags:

-c
print column names only instead of full column descriptions

Parameters:

table=string
table name
driver=string
driver name
Options: pg,dbf,mysql,ogr
database=string
database name

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.

EXAMPLE

db.describe -c table=test driver=dbf
ncols:2
Column 1: CAT
Column 2: BACK
Column 3: TIME
db.describe table=test
column:CAT
description:
type:INTEGER
len:11
scale:0
precision:10
default:0
nullok:yes
select:yes
update:yes

[...]

SEE ALSO

GRASS 5.7 tutorial pages, db.columns, db.droptable, db.execute, db.login, db.tables, GRASS SQL interface

AUTHOR

Radim Blazek, ITC-Irst, Trento, Italy

Last changed: $Date: 2004/12/08 13:45:39 $


Help Index