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

NAME

6       db.describe  - Describe a table (in detail).
7

KEYWORDS

9       database, SQL
10

SYNOPSIS

12       db.describe
13       db.describe help
14       db.describe [-c] table=string  [driver=string]   [database=string]
15
16   Flags:
17       -c  print column names only instead of full column descriptions
18
19   Parameters:
20       table=string
21           table name
22
23       driver=string
24           driver name Options: dbf,mysql,ogr,pg,sqlite,mesql,odbc
25
26       database=string
27           database name
28

DESCRIPTION

30       db.describe  displays  table  information. If parameter -c is used only
31       column names instead of full column descriptions is given.
32

NOTE

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

EXAMPLE

39
40       db.describe -c table=test driver=dbf
41       ncols:2
42       Column 1: CAT
43       Column 2: BACK
44       Column 3: TIME
45
46       db.describe table=test
47       column:CAT
48       description:
49       type:INTEGER
50       len:11
51       scale:0
52       precision:10
53       default:0
54       nullok:yes
55       select:yes
56       update:yes
57       [...]
58
59

SEE ALSO

61        db.columns, db.droptable, db.execute, db.login, db.tables,  GRASS  SQL
62       interface
63

AUTHOR

65       Radim Blazek, ITC-Irst, Trento, Italy
66
67       Last changed: $Date: 2005/12/10 17:49:50 $
68
69       Full index
70
71
72
73GRASS 6.2.2                                                     db.describe(1)