GRASS logo

NAME

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

KEYWORDS

database, SQL

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

db.columns, db.droptable, db.execute, db.login, db.tables, GRASS SQL interface

AUTHOR

Radim Blazek, ITC-Irst, Trento, Italy

Last changed: $Date: 2005/12/10 17:49:50 $


Main index - database index - Full index