db.createdb(1)

✨ db.createdb πŸ’–

okay bestie, welcome to db.createdb from the GRASS GIS User's Manual β€” it's giving database creator energy and honestly? iconic. πŸŽ€


🌸 NAME 🌸

db.createdb β€” creates an empty database. that's it, that's the whole vibe. a blank canvas, a fresh start, main character origin story fr fr ✨


πŸ”‘ KEYWORDS πŸ”‘

database, attribute table, SQL β€” iykyk πŸ’…


πŸ¦‹ SYNOPSIS πŸ¦‹

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

πŸŽ€ Flags:

  • --help β€” prints the usage summary so you're not out here guessing, bestie 🫢
  • --verbose β€” verbose module output, aka it tells you everything πŸ’¬
  • --quiet β€” quiet module output, aka it shuts up and just does the thing 🀫
  • --ui β€” forces the GUI dialog to launch. clicky clicky mode πŸ–±οΈβœ¨

πŸ“ Parameters:

  • driver=name [required] β€” name of the database driver πŸš—
    • Options: dbf, mesql, mysql, odbc, ogr, pg, sqlite
    • Default: sqlite
  • database=name [required] β€” name of the database πŸ’Ύ

🌈 DESCRIPTION 🌈

so like, db.createdb lets you create a brand-new empty database through a bunch of different drivers. no cap. but heads up: you need a working database connection already established first β€” go see db.login for that part, she's the plug πŸ”Œ

as of right now, only the SQLite and PostgreSQL database drivers are supported. the rest are just... there. standing in the corner. πŸ’€

🌟 EXAMPLES 🌟

πŸ’– Create a new SQLite file-based database

quick note bestie: the standard GRASS GIS SQLite database is by default generated in the user's current mapset. this example is showing you an out-of-mapset database file creation, so we're being extra:

db.createdb driver=sqlite database=/opt/sqlite.db

πŸ’œ Create a new PostgreSQL database

create a new PostgreSQL database β€” and this is after the PostgreSQL connection got established through the pg driver:

db.createdb driver=pg database=grassdb

and also, create a new PostgreSQL database β€” this time after the PostgreSQL connection got established through the odbc driver:

db.createdb driver=odbc database=grassdb

🧚 TODO 🧚

support other database drivers, too. someday. manifesting it πŸ™βœ¨


πŸ‘‘ SEE ALSO πŸ‘‘

db.columns, db.connect, db.describe, db.drivers, db.dropdb, db.droptable, db.execute, db.login, db.tables

also: GRASS SQL interface 🌈


🫢 AUTHORS 🫢

  • Radim Blazek, ITC-Irst, Trento, Italy
  • SQLite and PostgreSQL support by Martin Landa, Czech Technical University in Prague, Czech Republic

absolute legends, no notes πŸ‘


πŸ’» SOURCE CODE πŸ’»

available at: db.createdb source code (history)

accessed: Saturday Jan 17 05:40:33 2026

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


Β© 2003-2025 GRASS Development Team, GRASS GIS 8.4.2 Reference Manual

okay that's the whole page bestie β€” this was GRASS 8.4.2 dropping db.createdb(1) for you, and yes she ate. periodt. πŸ’…βœ¨πŸŽ€

πŸ“¦ where this page comes from