.TH db.describe 1grass "" "GRASS 6.4.4" "Grass User's Manual"
.SH NAME
\fI\fBdb.describe\fR\fR  - Describes a table in detail.
.SH KEYWORDS
database, attribute table
.SH SYNOPSIS
\fBdb.describe\fR
.br
\fBdb.describe help\fR
.br
\fBdb.describe\fR [\-\fBct\fR] \fBtable\fR=\fIname\fR  [\fBdriver\fR=\fIname\fR]   [\fBdatabase\fR=\fIname\fR]   [\-\-\fBverbose\fR]  [\-\-\fBquiet\fR] 
.SS Flags:
.IP "\fB\-c\fR" 4m
.br
Print column names only instead of full column descriptions
.IP "\fB\-t\fR" 4m
.br
Print table structure
.IP "\fB\-\-verbose\fR" 4m
.br
Verbose module output
.IP "\fB\-\-quiet\fR" 4m
.br
Quiet module output
.PP
.SS Parameters:
.IP "\fBtable\fR=\fIname\fR" 4m
.br
Table name
.IP "\fBdriver\fR=\fIname\fR" 4m
.br
Driver name
.br
Options: \fIpg,dbf,ogr,odbc,mysql,sqlite\fR
.br
Default: \fIdbf\fR
.IP "\fBdatabase\fR=\fIname\fR" 4m
.br
Database name
.br
Default: \fI$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/\fR
.PP
.SH DESCRIPTION
\fIdb.describe\fR displays table information. If parameter \fB-c\fR is used 
only column names instead of full column descriptions is given. 
.SH 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.
.SH EXAMPLE
\fC
.DS
.br
db.describe \-c table=roads database='$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/' \(rs
.br
            driver=dbf
.br
ncols:2
.br
Column 1:cat:INTEGER:11
.br
Column 2:label:CHARACTER:43
.br
.DE
\fR
\fC
.DS
.br
db.describe table=roads database='$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/' \(rs
.br
            driver=dbf
.br
table:roads
.br
description:
.br
insert:yes
.br
delete:yes
.br
ncols:2
.br
.br
column:cat
.br
description:
.br
type:INTEGER
.br
len:11
.br
scale:0
.br
precision:10
.br
default:
.br
nullok:yes
.br
select:yes
.br
update:yes
.br
[...]
.br
.DE
\fR
.SH SEE ALSO
\fI
db.columns,
db.droptable,
db.execute,
db.login,
db.tables,
GRASS SQL interface\fR
.SH AUTHOR
Radim Blazek, ITC-Irst, Trento, Italy
.PP
\fILast changed: $Date: 2011-11-08 10:42:51 +0100 (Tue, 08 Nov 2011) $\fR
.PP
Full index
.PP
© 2003-2014 GRASS Development Team