NAME

       db.columns  - List all columns for a given table.

KEYWORDS

       database, attribute table

SYNOPSIS

       db.columns
       db.columns help
       db.columns table=name  [driver=name]   [database=name]   [--verbose]  [--quiet]

   Parameters:
       table=name
           Table name

       driver=name
           Driver name
           Options: sqlite,mysql,odbc,pg,dbf,ogr
           Default: dbf

       database=name
           Database name
           Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/

DESCRIPTION

       db.columns  lists  all  columns for a give table. Connection to databases are supported through dbf, shp,
       odbc and pg drivers.

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

       List columns from PostgreSQL attribute table

       db.columns table=markveggy driver=pg database=grass60test

       If database parameters are already set

       db.columns table=markveggy

       List columns from Shape file with DBF attribute table

       db.columns table=network driver=dbf database=/daten/grassdata/fire/PERMANENT/dbf/

SEE ALSO

       db.connect, db.describe, db.drivers, db.droptable, db.execute, db.login, db.tables, GRASS SQL interface

AUTHOR

       Radim Blazek, ITC-Irst, Trento, Italy

       Last changed: $Date: 2011-11-08 01:42:51 -0800 (Tue, 08 Nov 2011) $

       Full index

       © 2003-2013 GRASS Development Team

GRASS 6.4.3                                                                                   db.columns(1grass)