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, attribute table
10

SYNOPSIS

12       db.columns
13       db.columns --help
14       db.columns   table=name    [driver=name]    [database=name]    [--help]
15       [--verbose]  [--quiet]  [--ui]
16
17   Flags:
18       --help
19           Print usage summary
20
21       --verbose
22           Verbose module output
23
24       --quiet
25           Quiet module output
26
27       --ui
28           Force launching GUI dialog
29
30   Parameters:
31       table=name [required]
32           Name of attribute table
33
34       driver=name
35           Name of database driver
36           Options: dbf, mesql, mysql, odbc, ogr, pg, sqlite
37           Default: sqlite
38
39       database=name
40           Name of database
41           Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db
42

DESCRIPTION

44       db.columns lists all columns for a give table. Connection to  databases
45       are supported through dbf, shp, odbc and pg drivers.
46

NOTE

48       If  parameters for database connection are already set with db.connect,
49       they are taken as default values and do not need to  be  spcified  each
50       time.
51

EXAMPLES

53   List columns of a PostgreSQL attribute table
54       db.columns table=zipcodes_wake driver=pg database=grassdb
55
56       If  the  database parameters are already set, the columns can be listed
57       directly
58       db.columns table=zipcodes_wake
59
60   List columns from Shape file with DBF attribute table
61       db.columns table=zipcodes_wake driver=dbf database=/grassdata/nc_spm_08/PERMANENT/dbf/
62
63   List columns of table in SQLite database
64       Note that the SQLite backend is the default setting.
65       db.columns driver=sqlite table=archsites database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’
66

SEE ALSO

68         db.connect,  db.describe,   db.drivers,   db.droptable,   db.execute,
69       db.login, db.tables, GRASS SQL interface
70
71       GRASS SQL interface
72

AUTHOR

74       Radim Blazek, ITC-Irst, Trento, Italy
75

SOURCE CODE

77       Available at: db.columns source code (history)
78
79       Main index | Database index | Topics index | Keywords index | Graphical
80       index | Full index
81
82       © 2003-2019 GRASS Development Team, GRASS GIS 7.8.2 Reference Manual
83
84
85
86GRASS 7.8.2                                                      db.columns(1)
Impressum