CREATE EXTENSION loads a new extension to 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.
- Create an extension and load it to the current database. The extension cannot be with the same name as those have been loaded.
CREATE EXTENSION [ IF NOT EXISTS ] extension_name
[ WITH ] [ SCHEMA schema_name ]
[ VERSION version ]
[ FROM old_version ];
Specifies the extension name.
Specifies the name of the schema where the extension is installed.
Specifies the version number of the extension.
Specifies the original version number of the extension.