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 has not been changed since it was added in PostgreSQL 9.1.
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