Contents
CREATE EXTENSION
A DDL command to create an extension
CREATE EXTENSION is a DDL command to create an extension.
CREATE EXTENSION was added in PostgreSQL 9.1.
Change history
- PostgreSQL 13
CREATE EXTENSION … FROM …syntax removed (commit 70a77320)
- PostgreSQL 9.6
CREATE EXTENSION … CASCADEsyntax added (commit b67aaf21)
- PostgreSQL 9.1
- added (commit d9572c4e)
Examples
Simplest variant:
postgres=# CREATE EXTENSION pg_stat_statements; CREATE EXTENSION
Extension creation in a user-specified schema:
postgres=# CREATE EXTENSION pg_stat_statements WITH SCHEMA pgss; CREATE EXTENSION
Extension creation in a user-specified schema is not possible with some extensions:
postgres=# CREATE EXTENSION adminpack WITH SCHEMA public; ERROR: extension "adminpack" must be installed in schema "pg_catalog"
Create an extension and any dependencies:
postgres=# CREATE EXTENSION bool_plperlu CASCADE; NOTICE: installing required extension "plperlu" CREATE EXTENSION
References
- PostgreSQL documentation: CREATE EXTENSION