table of contents
db.databases(1grass) | GRASS GIS User's Manual | db.databases(1grass) |
NAME¶
db.databases - Lists all databases for a given driver and location.
KEYWORDS¶
database, attribute table, SQL
SYNOPSIS¶
db.databases
db.databases --help
db.databases [driver=name] [location=name]
[--help] [--verbose] [--quiet] [--ui]
Flags:¶
Parameters:¶
- driver=name
-
Name of database driver
Options: dbf, mysql, odbc, ogr, pg, sqlite
Default: sqlite - location=name
-
Location
Path for SQLite driver, or connection string for PostgreSQL driver
DESCRIPTION¶
db.databases lists all databases for a given driver and optionally location.
NOTES¶
Currently supported database drivers are SQLite, PostgreSQL, and ODBC.
Default location for SQLite driver is the full path for the current mapset. For PostgreSQL driver it’s empty connection string.
EXAMPLES¶
List SQLite databases in the current mapset:
db.databases driver=sqlite
List SQLite databases in a given directory:
db.databases driver=sqlite location=/opt/sqlite
List PostgreSQL databases from database server running on given
port:
db.databases driver=pg location="host=server_name port=5333"
SEE ALSO¶
db.columns, db.describe, db.drivers, db.execute, db.login, db.tables
GRASS SQL interface
AUTHORS¶
Radim Blazek, ITC-Irst, Trento, Italy
Updated for GRASS 7 by Martin Landa, Czech Technical University in Prague,
Czech Republic
SOURCE CODE¶
Available at: db.databases source code (history)
Accessed: Saturday Jul 27 17:07:52 2024
Main index | Database index | Topics index | Keywords index | Graphical index | Full index
© 2003-2024 GRASS Development Team, GRASS GIS 8.4.0 Reference Manual
GRASS 8.4.0 |