PostgreSQL extensions

• CREATE EXTENSION pg_stat_statements;
• create extension pg_trgm;
• create extension btree_gist;
• create extension postgres_fdw;
• CREATE EXTENSION uuid-ossp;
• CREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public;
• CREATE EXTENSION IF NOT EXISTS timescaledb; (TimescaleDB installation)
• CREATE EXTENSION postgis;
• CREATE EXTENSION btree_gin;
• CREATE EXTENSION pg_partman;

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

• PostGIS

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
• Supabase
• TimescaleDB extension: brew install timescaledb
• plpgsql
• Temporal database
• brew install postgresql

See also

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