Extension

List all available extensions:-

select * from pg_available_extensions;

List all installed extensions of the selected database

SELECT * FROM pg_extension;

OR

\dx

Install

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
CREATE EXTENSION IF NOT EXISTS "btree_gist";