1db.describe(1)              GRASS GIS User's Manual             db.describe(1)
2
3
4

NAME

6       db.describe  - Describes a table in detail.
7

KEYWORDS

9       database, attribute table
10

SYNOPSIS

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

DESCRIPTION

47       db.describe displays table information. If parameter -c  is  used  only
48       column names instead of full column descriptions is given.
49

NOTE

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

EXAMPLES

56       List column descriptions of table in SQLite database (note that this is
57       the default setting)
58       db.describe driver=sqlite table=hospitals \
59          database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’
60       # or simply
61       db.describe myarchsites
62
63   DBF example
64       db.describe -c table=hospitals database=’$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/’ \
65                   driver=dbf
66       ncols: 16
67       nrows: 160
68       Column 1: cat:INTEGER:11
69       Column 2: OBJECTID:INTEGER:11
70       Column 3: AREA:DOUBLE PRECISION:20
71       [...]
72       db.describe table=hospitals database=’$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/’ \
73                   driver=dbf
74       table:hospitals
75       description:
76       insert:yes
77       delete:yes
78       ncols:16
79       nrows:160
80       column:cat
81       description:
82       type:INTEGER
83       len:11
84       scale:0
85       precision:10
86       default:
87       nullok:yes
88       select:yes
89       update:yes
90       column:OBJECTID
91       description:
92       type:INTEGER
93       [...]
94

SEE ALSO

96        db.columns, db.droptable, db.execute, db.login, db.tables,  GRASS  SQL
97       interface
98

AUTHOR

100       Radim Blazek, ITC-Irst, Trento, Italy
101

SOURCE CODE

103       Available at: db.describe source code (history)
104
105       Accessed: Saturday Jan 21 20:38:01 2023
106
107       Main index | Database index | Topics index | Keywords index | Graphical
108       index | Full index
109
110       © 2003-2023 GRASS Development Team, GRASS GIS 8.2.1 Reference Manual
111
112
113
114GRASS 8.2.1                                                     db.describe(1)