1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
<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>EXAMPLE</h2>
<em>List columns from PostgreSQL attribute table</em><br>
<b>db.columns table=</b><em>markveggy</em> <b>driver=</b><em>odbc</em>
<b>database=</b><em>grass51test</em>
<p>
<em>If database parameters are already set</em><br>
<b>db.columns table=</b><em>markveggy</em>
<p>
<em>List columns from Shape file with DBF attribute table</em><br>
<b>db.columns table=</b><em>network</em> <b>driver=</b><em>dbf</em>
<b>database=</b><em>/daten/grassdata/fire/PERMANENT/dbf/</em>
<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>
<h2>AUTHOR</h2>
Radim Blazek, ITC-Irst, Trento, Italy
<p><i>Last changed: $Date: 2004/12/08 13:45:39 $</i>
|
