Skip to content

SQL - PostgreSQL - Extensions

Source: https://gist.github.com/parallelo3301/260435228584f1dc85701e884c4c97c1

-- show active extensions
SELECT * FROM pg_catalog.pg_extension;

-- show available extensions
SELECT * FROM pg_catalog.pg_available_extensions;

-- enable extension
CREATE EXTENSION xy;

Backlinks:

list from [[SQL - PostgreSQL - Extensions]] AND -"Changelog"