Contents
DROP EXTENSION
A DDL command to create an extension
DROP EXTENSION is a DDL command to create an extension, its component objects and optionally any dependencies.
DROP EXTENSION was added in PostgreSQL 9.1 (commit d9572c4e).
Change history
DROP EXTENSION has not been changed since it was added in PostgreSQL 9.1.
- PostgreSQL 9.1
- added (commit d9572c4e)
Examples
Drop an extension:
postgres=# DROP EXTENSION pg_stat_statements ; DROP EXTENSION
Drop an extension and any dependent extensions:
postgres=# DROP EXTENSION plperlu CASCADE ; NOTICE: drop cascades to extension bool_plperlu DROP EXTENSION
References
- PostgreSQL documentation: DROP EXTENSION