db.databases(1grass)

🗄️ NAME

db.databases — the girlies that list all the databases for a given driver and location. periodt.

🏷️ KEYWORDS

database, attribute table, SQL 💅

✨ SYNOPSIS ✨

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

🚩 Flags

• --help — prints the usage summary, bestie. like a lil cheat sheet 🫶
• --verbose — verbose module output (she's telling you EVERYTHING)
• --quiet — quiet module output (she's giving mysterious, silent, elegant)
• --ui — forces launching the GUI dialog ✨

🎀 Parameters

• driver=name — name of the database driver Options: dbf, mysql, odbc, ogr, pg, sqlite Default: sqlite 💖
• location=name — the location Path for SQLite driver, or connection string for PostgreSQL driver

💜 DESCRIPTION

okay so db.databases lists all the databases for a given driver — and optionally for a given location too. that's it, that's the whole vibe. simple, iconic, does exactly what it says on the tin.

📝 NOTES

Currently supported database drivers are SQLite, PostgreSQL, and ODBC. no cap.

The default location for the SQLite driver is the full path for the current mapset. For the PostgreSQL driver it's an empty connection string. that's just how she rolls 🦋

🌸 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 a database server running on a 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: Friday Feb 07 19:16:09 2025 in commit: a82a39f673b97fafcfce1604dc3e6015cb96487a

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

---

© 2003-2026 GRASS Development Team, GRASS 8.5.0 Reference Manual 🌈

and that's the whole page bestie, GRASS 8.5.0 edition, db.databases(1grass), go forth and list those databases. slay 💅✨🎀