PostgreSQL – List installed extensions

Run the below sql to list all the extensions that are currently installed in your postgres database.

SELECT * FROM pg_extension;

Below is the query to view all the available extensions in Postgres database:

SELECT * FROM pg_available_extensions;

To install an extension, run the below command as a superuser, where extension_name is the name of the extension found in pg_available_extensions.

CREATE EXTENSION extension_name;
See also  PostgreSQL - Get table size