1db.columns(1)                 Grass User's Manual                db.columns(1)
2
3
4

NAME

6       db.columns  - list all columns for a given table.
7

KEYWORDS

9       database, SQL
10

SYNOPSIS

12       db.columns
13       db.columns help
14       db.columns table=string  [driver=string]   [database=string]
15
16   Parameters:
17       table=string
18           table name
19
20       driver=string
21           driver name Options: dbf,mysql,ogr,pg,sqlite,mesql,odbc
22
23       database=string
24           database name
25

DESCRIPTION

27       db.columns  lists all columns for a give table. Connection to databases
28       are supported through dbf, shp, odbc and pg drivers.
29

NOTE

31       If parameters for database connection are already set with  db.connect,
32       they  are  taken  as default values and do not need to be spcified each
33       time.
34

EXAMPLE

36       List columns from PostgreSQL attribute table
37
38       db.columns table=markveggy driver=pg database=grass60test
39
40
41       If database parameters are already set
42
43       db.columns table=markveggy
44
45
46       List columns from Shape file with DBF attribute table
47
48       db.columns table=network driver=dbf database=/daten/grassdata/fire/PER‐
49       MANENT/dbf/
50
51

SEE ALSO

53       db.connect,    db.describe,   db.drivers,   db.droptable,   db.execute,
54       db.login, db.tables, GRASS SQL interface
55

AUTHOR

57       Radim Blazek, ITC-Irst, Trento, Italy
58
59       Last changed: $Date: 2005/12/10 17:49:50 $
60
61       Full index
62
63
64
65GRASS 6.2.2                                                      db.columns(1)