• Browse categories
• Random entry
• PostgreSQL releases
  • PostgreSQL 16 (dev)
  • PostgreSQL 15 (latest)
  • PostgreSQL 14
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10 (EOL)

Version charts

Useful overviews

Useful links

CREATE DATABASE

CREATE DATABASE is a DDL command to create a database.

CREATE DATABASE has always been present in PostgreSQL.

Change history

• PostgreSQL 15
  • COLLATION_VERSION option added (commit 37851a8b)
  • ICU_LOCALE option added (commit f2553d43)
  • LOCALE_PROVIDER option added (commit f2553d43)
  • STRATEGY option added (commit 9c08aea6)
  • OID option added (commit aa010514)
• 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)

Examples

postgres=# CREATE DATABASE foo;
CREATE DATABASE

postgres=# \l+ foo
List of databases
-[ RECORD 1 ]-----+------------
Name              | foo
Owner             | postgres
Encoding          | UTF8
Collate           | en_GB.UTF-8
Ctype             | en_GB.UTF-8
Access privileges | 
Size              | 7393 kB
Tablespace        | pg_default
Description       | 

postgres=# CREATE DATABASE locale_test
                  ENCODING latin1
                    LOCALE 'de_DE.iso88591'
                  TEMPLATE template0;
CREATE DATABASE

postgres=# \l+ locale_test 
List of databases
-[ RECORD 1 ]-----+---------------
Name              | locale_test
Owner             | postgres
Encoding          | LATIN1
Collate           | de_DE.iso88591
Ctype             | de_DE.iso88591
Access privileges | 
Size              | 7393 kB
Tablespace        | pg_default
Description       | 

References

Categories

See also