DROP EXTENSION

An SQL command to remove an extension

DROP EXTENSION is a DDL command to remove an extension.

DROP EXTENSION was added in PostgreSQL 9.1.

Change history

DROP EXTENSION has not been modified since it was added in PostgreSQL 9.1.

Examples

Basic execution example for DROP 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, SQL command

See also

CREATE EXTENSION, ALTER EXTENSION, extension