db.tables(1grass)

πŸ’… db.tables (GRASS User's Manual, bestie edition) πŸ‘‘

okay so babes, welcome to the db.tables page β€” straight outta the GRASS User's Manual and into your group chat. this one is a lil cutie that does exactly one thing and does it slay, so let's get into it ✨

🌸 NAME 🌸

db.tables β€” she lists all the tables for a given database. that's it. that's the girl. πŸ’–

🏷️ KEYWORDS 🏷️

database</purlple>, attribute table

(no that's not a typo, those are literally the keywords, periodt.)

✨ SYNOPSIS ✨

db.tables
db.tables --help
db.tables [-ps]  [driver=name]   [database=name]   [--help]  [--verbose]
[--quiet]  [--ui]

🚩 Flags 🚩

  • -p β€” print the tables and dip 🫑 (prints them, then exits)
  • -s β€” show the system tables instead of the user tables πŸ‘€
  • --help β€” print the usage summary, for when you're lost (no shame)
  • --verbose β€” verbose module output, she's chatty πŸ’¬
  • --quiet β€” quiet module output, she's giving mysterious 🧚
  • --ui β€” force launching the GUI dialog. yes, a whole GUI. iconic.

πŸŽ€ Parameters πŸŽ€

  • driver=name β€” name of the database driver
    • Options: dbf, mysql, odbc, ogr, pg, sqlite
    • Default: sqlite
  • database=name β€” name of the database
    • Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db

πŸ’– DESCRIPTION πŸ’–

fr fr, this is the whole thing: db.tables lists all tables for a given database. short king of a module. no cap, that's the description.

πŸ“ NOTE πŸ“

If the parameters for the database connection are already set with db.connect, they get taken as the default values β€” so you don't gotta specify them every single time. lowkey the bestie behavior we love to see. 🫢

🌈 EXAMPLES 🌈

πŸ“ List all tables if the 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 a SQLite database (note that this is the default setting)

db.tables -p driver=sqlite database=’$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db’
(yes bestie, default means sqlite β€” you literally don't have to type it, but here she is anyway πŸ’…)

πŸ‘€ SEE ALSO πŸ‘€

db.columns, db.droptable, db.login, db.execute, GRASS SQL interface

🧚 AUTHOR 🧚

Unknown πŸ€·β™€οΈ (mysterious. main character energy. we don't know her, but we respect her.)

πŸ’» SOURCE CODE πŸ’»

Available at: db.tables source code (history)

Latest change: Saturday Mar 01 15:13:00 2025 in commit: 45f0c946963404fa7769228aaa95f2202cff977e

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


okay that's the whole page bestie, you ate that πŸŽ€βœ¨ and now the cute little sign-off: this whole thing is Β© 2003-2026 GRASS Development Team, from the GRASS 8.5.0 Reference Manual. mwah πŸ’‹ slay, go list some tables πŸ’–πŸ¦‹

πŸ“¦ where this page comes from