---
name: "db.createdb"
section: "1grass"
platform: "linux"
package: "grass-doc"
version: "8.4.1-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/db.createdb"
---

# db.createdb(1grass)

Creates an empty database.

## 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)

Accessed: Monday Feb 24 17:50:22 2025

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

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