DROP EXTENSION deletes extensions from the database.
The syntax is only available in extended mode (when GUC parameter support_extended_features is on). Exercise caution when enabling the mode. It is used for tools like internal upgrade tools. Common users should not use the mode.
DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ];
Sends a notice instead of an error if the specified extension does not exist.
Specifies the name of an extension to be deleted.