db.describe - Describes a table in detail.

       Radim Blazek, ITC-Irst, Trento, Italy

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

ListcolumndescriptionsoftableinSQLitedatabase(notethatthisisthedefaultsetting)
       db.describe driver=sqlite table=hospitals \
          database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’
       # or simply
       db.describe myarchsites

   DBFexample
       db.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
       [...]

       database, attribute table

db.describe  - Describes a table in detail.

       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.

db.columns,db.droptable,db.execute,db.login,db.tables,GRASSSQLinterface

       Available at: db.describe source code (history)

       Accessed: Friday Apr 04 01:18:43 2025

       Main index | Database index | Topics index | Keywords index | Graphical index | Full index

       © 2003-2025 GRASS Development Team, GRASS GIS 8.4.1 Reference Manual

GRASS 8.4.1                                                                                  db.describe(1grass)

db.describedb.describe--helpdb.describe [-c] table=name  [driver=name]   [database=name]   [--help]  [--verbose]  [--quiet]  [--ui]

   Flags:-c
           Print column names only instead of full column descriptions

       --help
           Print usage summary

       --verbose
           Verbose module output

       --quiet
           Quiet module output

       --ui
           Force launching GUI dialog

   Parameters:table=name[required]
           Name of attribute table

       driver=name
           Name of database driver
           Options: dbf,mysql,odbc,ogr,pg,sqlite
           Default: sqlitedatabase=name
           Name of database
           Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db