.TH db.columns 1grass "" "GRASS 6.4.4" "Grass User's Manual"
.SH NAME
\fI\fBdb.columns\fR\fR  - List all columns for a given table.
.SH KEYWORDS
database, attribute table
.SH SYNOPSIS
\fBdb.columns\fR
.br
\fBdb.columns help\fR
.br
\fBdb.columns table\fR=\fIname\fR  [\fBdriver\fR=\fIname\fR]   [\fBdatabase\fR=\fIname\fR]   [\-\-\fBverbose\fR]  [\-\-\fBquiet\fR] 
.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.columns\fR lists all columns for a give table. Connection to 
databases are supported through dbf, shp, odbc and pg drivers.  
.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
\fIList columns from PostgreSQL attribute table\fR
.br
\fC
.DS
.br
db.columns table=markveggy driver=pg database=grass60test
.br
.DE
\fR
.PP
\fIIf database parameters are already set\fR
.br
\fC
.DS
.br
db.columns table=markveggy
.br
.DE
\fR
.PP
\fIList columns from Shape file with DBF attribute table\fR
.br
\fC
.DS
.br
db.columns table=network driver=dbf database=/daten/grassdata/fire/PERMANENT/dbf/
.br
.DE
\fR
.SH SEE ALSO
\fIdb.connect,
db.describe,
db.drivers,
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