NAME
g.column.pg - Generate a list of database columns for a specified
table in the currently selected database. (GRASS-RDBMS General Interface
Program)
SYNOPSIS
g.column.pg
g.column.pg help
g.column.pg [-v] table=name
DESCRIPTION
g.column.pg is used to generate a list of the columns in the specified
table [table] of the currenty selected database. If the [-v] option
is used the data type and length of the column are reported as well. The
currently selected database is identified by the GRASS environment variable
$PG_DBASE which is set using the g.select.pg GRASS-RDBMS interface
tool. If this environment variable is not set the program terminates with
a message to the user. To generate a list of the available tables in the
currently selected database use the command g.table.pg. The information
provided by g.column.pg will be used in subsequent GRASS-RDBMS applications
to formulate and construct well formed database queries.
COMMAND LINE OPTIONS
Flag:
-
-v
-
Use v for a verbose listing of columns
Parameter:
-
table=databasetablename
-
Name of table in the currently selected database.
EXAMPLE OUTPUT (terse)
g.column.pg table=nri
The following columns are defined in table: utm
fips flood hydunit
landcl82 landcl87 mlra
nriptr other point
psu refname slope
soil5 textmod texture
tfact ukfact utme
utmn xfact
EXAMPLE OUTPUT (verbose)
g.column.pg table=nri -v
The following columns are defined in table: utm
flood char16
hydunit char16
landcl82 char
landcl87 char
mlra char16
nriptr int4
other text
BUGS
None known.
NOTE
This program requires the Postgres database software.
SEE ALSO
g.select.pg, g.stats.pg,
g.table.pg, d.rast.pg,
d.site.pg, d.vect.pg,
d.what.r.pg, d.what.s.pg,
d.what.v.pg, r.reclass.pg,
r.rescale.pg, v.reclass.pg
AUTHOR
Original Informix SQL-tools: James A. Farley, Wang Song, and W. Fredrick
Limp University of Arkansas, CAST
Postgres modifications: Janne Soimasuo, Faculty of Forestry, University
of Joensuu, Finland.
Updated to GRASS 5 by Alex Shevlakov (sixote@yahoo.com)