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