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

DESCRIPTION

50       db.describe displays table information. If parameter -c  is  used  only
51       column names instead of full column descriptions is given.
52

NOTE

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

EXAMPLES

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

SEE ALSO

99        db.columns, db.droptable, db.execute, db.login, db.tables,  GRASS  SQL
100       interface
101

AUTHOR

103       Radim Blazek, ITC-Irst, Trento, Italy
104

SOURCE CODE

106       Available at: db.describe source code (history)
107
108       Main index | Database index | Topics index | Keywords index | Graphical
109       index | Full index
110
111       © 2003-2020 GRASS Development Team, GRASS GIS 7.8.5 Reference Manual
112
113
114
115GRASS 7.8.5                                                     db.describe(1)