DROP EXTENSION

A DDL command to create an extension, its component objects and optionally any dependencies

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.

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

Categories

DDL, Extension

See also

CREATE EXTENSION, ALTER EXTENSION, extension