|
NAMEdb.describe - Describes a table in detail.KEYWORDSdatabase, attribute tableSYNOPSISdb.describedb.describe --help db.describe [-ct] table=name [driver=name] [database=name] [--help] [--verbose] [--quiet] [--ui] Flags:
Parameters:
DESCRIPTIONdb.describe displays table information. If parameter -c is used only column names instead of full column descriptions is given.NOTEIf 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.EXAMPLESList column descriptions of table in SQLite database (note that this is the default setting)db.describe driver=sqlite table=hospitals \ database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’ # or simply db.describe myarchsites DBF exampledb.describe -c table=hospitals database=’$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/’ \ driver=dbf ncols: 16 nrows: 160 Column 1: cat:INTEGER:11 Column 2: OBJECTID:INTEGER:11 Column 3: AREA:DOUBLE PRECISION:20 [...] db.describe table=hospitals database=’$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/’ \ driver=dbf table:hospitals description: insert:yes delete:yes ncols:16 nrows:160 column:cat description: type:INTEGER len:11 scale:0 precision:10 default: nullok:yes select:yes update:yes column:OBJECTID description: type:INTEGER [...] SEE ALSOdb.columns, db.droptable, db.execute, db.login, db.tables, GRASS SQL interfaceAUTHORRadim Blazek, ITC-Irst, Trento, ItalySOURCE CODEAvailable at: db.describe source code (history)Main index | Database index | Topics index | Keywords index | Graphical index | Full index © 2003-2021 GRASS Development Team, GRASS GIS 7.8.6 Reference Manual
Visit the GSP FreeBSD Man Page Interface. |