## 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)