Geografic-Information-System/db/db.columns/db.columns.html

<h2>DESCRIPTION</h2>

<em>db.columns</em> lists all columns for a give table. Connection to 
databases are supported through dbf, shp, odbc and pg drivers.  

<h2>NOTE</h2>

If parameters for database connection are already set with
<a href="db.connect.html">db.connect</a>, they are taken as default values
and do not need to be spcified each time.

<h2>EXAMPLES</h2>

<h3>List columns of a PostgreSQL attribute table</h3>

<div class="code"><pre>
db.columns table=zipcodes_wake driver=pg database=grassdb
</pre></div>

<p>
<em>If the database parameters are already set, the columns can be listed
directly</em><br>

<div class="code"><pre>
db.columns table=zipcodes_wake
</pre></div>

<h3>List columns from Shape file with DBF attribute table</h3>

<div class="code"><pre>
db.columns table=zipcodes_wake driver=dbf database=/grassdata/nc_spm_08/PERMANENT/dbf/
</pre></div>

<h3>List columns of table in SQLite database</h3>

Note that the SQLite backend is the default setting.

<div class="code"><pre>
db.columns driver=sqlite table=archsites database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db'
</pre></div>

<h2>SEE ALSO</h2>
<em>
<a href="db.connect.html">db.connect</a>,
<a href="db.describe.html">db.describe</a>,
<a href="db.drivers.html">db.drivers</a>,
<a href="db.droptable.html">db.droptable</a>,
<a href="db.execute.html">db.execute</a>,
<a href="db.login.html">db.login</a>,
<a href="db.tables.html">db.tables</a>,
<a href="sql.html">GRASS SQL interface</a>
</em>
<p>
<a href="sql.html">GRASS SQL interface</a>

<h2>AUTHOR</h2>

Radim Blazek, ITC-Irst, Trento, Italy

<p><i>Last changed: $Date$</i>