Contents

Change history
References
Categories
See also

CREATE DATABASE

A DDL command to create a database

CREATE DATABASE is a DDL command to create a database.

CREATE DATABASE has always been present in PostgreSQL.

Change history

PostgreSQL 13
- LOCALE option added, combining the existing LC_COLLATE and LC_CTYPE options (commit 06140c20)
PostgreSQL 9.5
- ALLOW_CONNECTIONS option added (commit fbb1d7d7)
- IS_TEMPLATE option added (commit fbb1d7d7)
PostgreSQL 9.0
- LC_COLLATE option added (initial commit 61d96749)
- LC_CTYPE option added (initial commit 61d96749)
PostgreSQL 8.1
- CONNECTION LIMIT option added (commit d42cf5a4)
PostgreSQL 8.0
- TABLESPACE option added to define the default tablespace for the database (commit 2467394e)
- LOCATION option removed (commit 2467394e)
PostgreSQL 7.3
- OWNER option added to enable specification of the database owner on database creation (commit a833c441)
PostgreSQL 7.1
- WITH TEMPLATE option added to enable selection of a template database as an alternative to the default "template0" (commit 2cf48ca0)

References

PostgreSQL documentation: CREATE DATABASE
PostgreSQL documentation: Creating a Database

Categories

See also

createdb, ALTER DATABASE, DROP DATABASE