db.tables.1grass man page

db.tables — Lists all tables for a given database.

Keywords

database, attribute table

Synopsis

db.tables
db.tables --help
db.tables [-ps]  [driver=name]   [database=name]   [--help]  [--verbose]  [--quiet]  [--ui]

Flags

-p

Print tables and exit

-s

System tables instead of user tables

--help

Print usage summary

--verbose

Verbose module output

--quiet

Quiet module output

--ui

Force launching GUI dialog

Parameters

driver=name

Name of database driver
Options: pg, ogr, odbc, mysql, sqlite, dbf, mesql
Default: sqlite

database=name

Name of database
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db

Description

db.tables lists all tables for a given database.

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.

Examples

List all tables if database connection is already set

db.tables -p

List all DBF tables

db.tables driver=dbf database=/grassdata/nc_spm_08/user1/PERMANENT/dbf

List all tables in SQLite database (note that this is the default setting)

db.tables -p driver=sqlite database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’

See Also

db.columns, db.droptable, db.login, db.execute, GRASS SQL interface

Author

Unknown

Last changed: $Date: 2014-11-28 10:58:18 +0100 (Fri, 28 Nov 2014) $

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

© 2003-2016 GRASS Development Team, GRASS GIS 7.0.4 Reference Manual

Info

GRASS 7.0.4 Grass User's Manual