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=name   [driver=name]    [database=name]   [--verbose]
15       [--quiet]
16
17   Parameters:
18       table=name
19           Table name
20
21       driver=name
22           Driver name
23           Options: ogr,odbc,pg,sqlite,mesql
24           Default: dbf
25
26       database=name
27           Database name
28           Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
29

DESCRIPTION

31       db.columns lists all columns for a give table. Connection to  databases
32       are supported through dbf, shp, odbc and pg drivers.
33

NOTE

35       If  parameters for database connection are already set with db.connect,
36       they are taken as default values and do not need to  be  spcified  each
37       time.
38

EXAMPLE

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

SEE ALSO

57       db.connect,   db.describe,   db.drivers,   db.droptable,    db.execute,
58       db.login, db.tables, GRASS SQL interface
59

AUTHOR

61       Radim Blazek, ITC-Irst, Trento, Italy
62
63       Last changed: $Date: 2005-12-10 18:49:50 +0100 (Sat, 10 Dec 2005) $
64
65       Full index
66
67       © 2003-2008 GRASS Development Team
68
69
70
71GRASS 6.3.0                                                      db.columns(1)