PostgreSQL extensions

CREATE EXTENSION
CREATE EXTENSION pg_stat_statements;
CREATE EXTENSION uuid-ossp

• List available extensions: ~/brew/share/postgresql@17/extension/

List extensions:

• SELECT * FROM pg_extension;
• SELECT * FROM pg_available_extensions;
• \dx

\connect your-timescalen-db-name

SELECT extversion FROM pg_extension where extname = 'timescaledb';

Related

• ZomboDB
• TimescaleDB extension
• plpgsql
• Temporal database
• brew install postgresql

See also

• CREATE EXTENSION pg_stat_statements, ~/brew/share/postgresql@17/extension/
• PostgreSQL, PostgreSQL extensions, CREATE EXTENSION, List extensions (\dx)