DOKK / manpages / debian 10 / grass-doc / db.databases.1grass.en
db.databases(1grass) Grass User's Manual db.databases(1grass)

db.databases - Lists all databases for a given driver and location.

database, attribute table, SQL

db.databases
db.databases --help
db.databases [driver=name] [location=name] [--help] [--verbose] [--quiet] [--ui]


Print usage summary

Verbose module output

Quiet module output

Force launching GUI dialog


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

Location
Path for SQLite driver, or connection string for PostgreSQL driver

db.databases lists all databases for a given driver and optionally location.

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.

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"

db.columns, db.describe, db.drivers, db.execute, db.login, db.tables

GRASS SQL interface

Radim Blazek, ITC-Irst, Trento, Italy
Updated for GRASS 7 by Martin Landa, Czech Technical University in Prague, Czech Republic

Last changed: $Date: 2014-12-07 23:22:14 +0100 (Sun, 07 Dec 2014) $

Available at: db.databases source code (history)

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

© 2003-2019 GRASS Development Team, GRASS GIS 7.6.0 Reference Manual

GRASS 7.6.0