Rechercher une page de manuel
db.describe
Langue: en
Version: 372644 (fedora - 01/12/10)
Section: 1 (Commandes utilisateur)
NAME
db.describe - Describes a table in detail.KEYWORDS
database, SQLSYNOPSIS
db.describedb.describe help
db.describe [-ct] table=name [driver=name] [database=name] [--verbose] [--quiet]
Flags:
- -c
Print column names only instead of full column descriptions- -t
Print table structure- --verbose
Verbose module output- --quiet
Quiet module output
Parameters:
- table=name
Table name- driver=name
Driver name
Options: ogr,odbc,pg,mysql,sqlite,mesql
Default: dbf- database=name
Database name
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/dbf/
DESCRIPTION
db.describe displays table information. If parameter -c is used only column names instead of full column descriptions is given.NOTE
If parameters for database connection are already set with db.connect, they are taken as default values and do not need to be spcified each time.EXAMPLE
db.describe -c table=roads database='$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/' rs
driver=dbf
ncols:2
Column 1:cat:INTEGER:11
Column 2:label:CHARACTER:43
db.describe table=roads database='$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/' rs
driver=dbf
table:roads
description:
insert:yes
delete:yes
ncols:2
column:cat
description:
type:INTEGER
len:11
scale:0
precision:10
default:
nullok:yes
select:yes
update:yes
[...]
SEE ALSO
db.columns, db.droptable, db.execute, db.login, db.tables, GRASS SQL interfaceAUTHOR
Radim Blazek, ITC-Irst, Trento, ItalyLast changed: $Date: 2007-04-07 18:18:51 +0200 (Sat, 07 Apr 2007) $
Full index
© 2003-2008 GRASS Development Team
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre