g.table.pg
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 $PGDBASE 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 dbSQL 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)