Rechercher une page de manuel
db.columns
Langue: en
Version: 369718 (fedora - 01/12/10)
Section: 1 (Commandes utilisateur)
NAME
db.columns - List all columns for a given table.KEYWORDS
database, SQLSYNOPSIS
db.columnsdb.columns help
db.columns table=name [driver=name] [database=name] [--verbose] [--quiet]
Parameters:
- table=name
Table name- driver=name
Driver name
Options: ogr,odbc,pg,sqlite,mesql
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 tabledb.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 interfaceAUTHOR
Radim Blazek, ITC-Irst, Trento, ItalyLast changed: $Date: 2005-12-10 18:49:50 +0100 (Sat, 10 Dec 2005) $
Full index
© 2003-2008 GRASS Development Team
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre