db.createdb.1grass - Man Page
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, mesql, 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: Tuesday Mar 19 11:01:48 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