Enable and manage extensions in PostgreSQL Flex

In this how-to guide you learn how-to enable and manage extensions in PostgreSQL Flex. For a list of supported extensions, consult Supported extensions in PostgreSQL Flex.

Check allowed extensions from a SQL query

You can also check the allowed extensions you can install by running the following query on your database instance:

show extwlist.extensions ;

How-to install an extension

PostgreSQL Flex allows to create postgres extensions by running the SQL commands to create, drop or update the extensions.

Create an extension

Once you checked that your required extensions is on the list, you can add it using the CREATE EXTENSION command like:

CREATE EXTENSION IF NOT EXISTS extension_name;

Drop an extension

You can also drop any extension you no longer require using the DROP EXTENSION command like:

DROP EXTENSION IF EXISTS extension_name;

Update an extension

An extension can be updated to a newer version(if any) as the following example.

ALTER EXTENSION extension_name UPDATE;