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

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: dbf,odbc,pg,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