g.column.pg(1)		      Grass User's Manual		g.column.pg(1)



NNAAMMEE
       _g_._c_o_l_u_m_n_._p_g - Generate a list of database columns for a specified table
       in the currently selected database. (GRASS-RDBMS General Interface Pro-
       gram)

SSYYNNOOPPSSIISS
       gg..ccoolluummnn..ppgg

       gg..ccoolluummnn..ppgg hheellpp

       gg..ccoolluummnn..ppgg [[--vv]] ttaabbllee_=_n_a_m_e

DDEESSCCRRIIPPTTIIOONN
       _g_._c_o_l_u_m_n_._p_g  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_._s_e_l_e_c_t_._p_g 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 avail-
       able tables in the currently selected database use  the	command  _g_._t_a_-
       _b_l_e_._p_g.	The information provided by _g_._c_o_l_u_m_n_._p_g will be used in subse-
       quent GRASS-RDBMS applications to formulate and construct  well	formed
       database queries.

CCOOMMMMAANNDD LLIINNEE OOPPTTIIOONNSS
   FFllaagg::
       --vv  Use v for a verbose listing of columns


   PPaarraammeetteerr::
       ttaabbllee==ddaattaabbaasseettaabblleennaammee
	   Name of table in the currently selected database.

       EEXXAAMMPPLLEE OOUUTTPPUUTT ((tteerrssee))

       _g_._c_o_l_u_m_n_._p_g _t_a_b_l_e_=_n_r_i

       The following columns are defined in table: utm

	      landcl82	       landcl87 	 mlra
	      nriptr	       other		 point
	      psu	       refname		 slope
	      soil5	       textmod		 texture
	      tfact	       ukfact		 utme
	      utmn	       xfact
       EEXXAAMMPPLLEE OOUUTTPPUUTT ((vveerrbboossee))

       _g_._c_o_l_u_m_n_._p_g _t_a_b_l_e_=_n_r_i _-_v

       The following columns are defined in table: utm

			   hydunit  char16
			  landcl82  char
			  landcl87  char
			      mlra  char16
			    nriptr  int4
			     other  text


BBUUGGSS
       None known.

NNOOTTEE
       This program requires the Postgres database software.

SSEEEE AALLSSOO
       _g_._s_t_a_t_s_._p_g_,
       _d_._r_a_s_t_._p_g_,
       _d_._v_e_c_t_._p_g_,
       _d_._w_h_a_t_._s_._p_g_,
       _r_._r_e_c_l_a_s_s_._p_g_,
       _v_._r_e_c_l_a_s_s_._p_g

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



GRASS 5.0							g.column.pg(1)
