db.createdb(1grass) GRASS GIS User's Manual db.createdb(1grass)

db.createdb - Creates an empty database.

database, attribute table, SQL

db.createdb
db.createdb --help
db.createdb driver=name database=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

Name of database

db.createdb allows the user to create a new empty database through different drivers. A working database connection needs to be established, see db.login.

Currently only SQLite and PostgreSQL database drivers are supported.

Note that the standard GRASS GIS SQLite database is by default generated in the user’s current mapset. This example shows an out-of-mapset database file creation: 

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

Create a new PostgreSQL database (after the PostgreSQL connection got established through the pg driver): 

db.createdb driver=pg database=grassdb

Create a new PostgreSQL database (after the PostgreSQL connection got established through the odbc driver): 

db.createdb driver=odbc database=grassdb

Support other database drivers, too.

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

GRASS SQL interface

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

Available at: db.createdb source code (history)

Accessed: Monday Apr 01 03:07:08 2024

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

© 2003-2024 GRASS Development Team, GRASS GIS 8.3.2 Reference Manual

GRASS 8.3.2