GRASS logo

Note: This document is for an older version of GRASS GIS that will be discontinued soon. You should upgrade, and read the current manual page.

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:

--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: dbf, odbc, ogr, pg, sqlite
Default: sqlite
location=name
Location
Path for SQLite driver, or connection string for PostgreSQL driver

Table of contents

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)

Latest change: Thursday Feb 03 11:10:06 2022 in commit: 547ff44e6aecfb4c9cbf6a4717fc14e521bec0be


Note: This document is for an older version of GRASS GIS that will be discontinued soon. You should upgrade, and read the current manual page.

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

© 2003-2023 GRASS Development Team, GRASS GIS 8.2.2dev Reference Manual