CREATE EXTENSION

• https://www.postgresql.org/docs/current/sql-createextension.html

CREATE EXTENSION [ IF NOT EXISTS ] extension_name
   [ WITH ] [ SCHEMA schema_name ]
            [ VERSION version ]
            [ CASCADE ]

Examples

• CREATE EXTENSION pg_stat_statements;
• CREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public;
• CREATE EXTENSION uuid-ossp;
• TimescaleDB installation: CREATE EXTENSION IF NOT EXISTS timescaledb;

Related

• PostgreSQL extensions
• SELECT * FROM pg_extension;

See also

• PostgreSQL, PostgreSQL extensions, CREATE EXTENSION, List extensions (\dx)