Homepage > Man Pages > Category > General Commands
Homepage > Man Pages > Name > D

db.columns

man page of db.columns

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

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: dbf,odbc,pg,mysql,sqlite,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: 2005-12-10 18:49:50 +0100 (Sat, 10 Dec 2005) $ Full index (C) 2003-2010 GRASS Development Team DB.COLUMNS(1)
 
 
 

Copyright © 2011–2018 by topics-of-interest.com . All rights reserved. Hosted by all-inkl.
Contact · Imprint · Privacy

Page generated in 26.96ms.

holzspalter.name | get-ip.de | Ermitteln Sie Ihre IP-Adresse schnell und einfach