NAME
g.table.pg - Generate a list of database tables in the currently
selected database. (GRASS-RDBMS General Interface Program)
SYNOPSIS
g.table.pg
g.table.pg help
DESCRIPTION
g.table.pg is used to generate a list of the tables in the currently
selected SQL database. 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. Otherwise, the names of
the tables in the currently selected database are displayed on the screen
in three columns. The names of the tables in the current database are needed
to construct query criteria for use in many of the other tools. This command
can be run at any time and is provided for reference purposes, to be used
while performing GRASS-RDBMS applications.
COMMAND LINE OPTIONS
None
EXAMPLE
g.table.pg
The following tables are available in database: nri
county cover geoaggs
hydros landclass locks
mlra nrifldvals point
practices priors psu
psutrends recorders state
stdrpts streams treatments
trends82 trends87 udrpt
udsubj utm valuelist
water windbreaks
BUGS
None known.
NOTE
This program requires the Postgres database software.
SEE ALSO
g.column.pg, g.select.pg,
g.stats.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)