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;