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

NAME

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

KEYWORDS

9       database, SQL
10

SYNOPSIS

12       db.describe
13       db.describe help
14       db.describe [-ct] table=name  [driver=name]   [database=name]   [--ver‐
15       bose]  [--quiet]
16
17   Flags:
18       -c
19           Print column names only instead of full column descriptions
20
21       -t
22           Print table structure
23
24       --verbose
25           Verbose module output
26
27       --quiet
28           Quiet module output
29
30   Parameters:
31       table=name
32           Table name
33
34       driver=name
35           Driver name
36           Options: ogr,odbc,pg,mysql,sqlite,mesql
37           Default: dbf
38
39       database=name
40           Database name
41           Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
42

DESCRIPTION

44       db.describe displays table information. If parameter -c  is  used  only
45       column names instead of full column descriptions is given.
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

EXAMPLE

53
54       db.describe  -c  table=roads  database='$GISDBASE/$LOCATION_NAME/PERMA‐
55       NENT/dbf/' \
56                   driver=dbf
57       ncols:2
58       Column 1:cat:INTEGER:11
59       Column 2:label:CHARACTER:43
60
61       db.describe    table=roads    database='$GISDBASE/$LOCATION_NAME/PERMA‐
62       NENT/dbf/' \
63                   driver=dbf
64       table:roads
65       description:
66       insert:yes
67       delete:yes
68       ncols:2
69       column:cat
70       description:
71       type:INTEGER
72       len:11
73       scale:0
74       precision:10
75       default:
76       nullok:yes
77       select:yes
78       update:yes
79       [...]
80
81

SEE ALSO

83         db.columns,  db.droptable, db.execute, db.login, db.tables, GRASS SQL
84       interface
85

AUTHOR

87       Radim Blazek, ITC-Irst, Trento, Italy
88
89       Last changed: $Date: 2007-04-07 18:18:51 +0200 (Sat, 07 Apr 2007) $
90
91       Full index
92
93       © 2003-2008 GRASS Development Team
94
95
96
97GRASS 6.3.0                                                     db.describe(1)