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

Version charts

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

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

CREATE SCHEMA

A DDL command for defining a new schema

CREATE SCHEMA is a DDL command for defining a new schema.

CREATE SCHEMA was added in PostgreSQL 7.3.

Change history

PostgreSQL 9.5
- CURRENT_USER and SESSION_USER available for CREATE SCHEMA [...] AUTHORIZATION ... (commit 31eae602)
PostgreSQL 9.3
- CREATE SCHEMA IF NOT EXISTS syntax added (commit fb34e94d)
PostgreSQL 7.3
- added (initial commit 95ef6a34)

References

PostgreSQL documentation: CREATE SCHEMA

Categories

See also

ALTER SCHEMA, DROP SCHEMA, pg_namespace