table of contents
db.createdb(1grass) | GRASS GIS User's Manual | db.createdb(1grass) |
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:¶
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)
Accessed: Sunday Jan 22 07:35:49 2023
Main index | Database index | Topics index | Keywords index | Graphical index | Full index
© 2003-2023 GRASS Development Team, GRASS GIS 8.2.1 Reference Manual
GRASS 8.2.1 |