db.createdb - Creates an empty database.

NAME  KEYWORDS  SYNOPSIS  Flags:  Parameters:  DESCRIPTION  EXAMPLES  Create a new SQLite file−based database  Create a new PostgreSQL database  TODO  SEE ALSO  AUTHORS  SOURCE CODE 

---

NAME

db.createdb − Creates an empty database.

KEYWORDS

database, attribute table, SQL

SYNOPSIS

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

Name of database driver
Options: dbf, mysql, odbc, ogr, pg, sqlite
Default: sqlite

database=name [required]

Name of database

DESCRIPTION

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.

EXAMPLES

Create a new SQLite file−based database

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

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

TODO

Support other database drivers, too.

SEE ALSO

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

GRASS SQL interface

AUTHORS

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

SOURCE CODE

Available at: db.createdb source code (history)

Latest change: Thursday Jan 26 14:10:26 2023 in commit: cdd84c130cea04b204479e2efdc75c742efc4843

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

© 2003−2025 GRASS Development Team, GRASS GIS 8.4.1 Reference Manual

---