Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

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