Scroll to navigation

db.tables(1grass) GRASS GIS User's Manual db.tables(1grass)

NAME

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:


Print tables and exit

System tables instead of user tables

Print usage summary

Verbose module output

Quiet module output

Force launching GUI dialog

Parameters:


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

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

SOURCE CODE

Available at: db.tables source code (history)

Accessed: Sunday Jan 22 07:35:50 2023

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

© 2003-2023 GRASS Development Team, GRASS GIS 8.2.1 Reference Manual

GRASS 8.2.1