PostgreSQL extensions
(Redirected from Pg extension)
Jump to navigation
Jump to search
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;
- List available extensions: ~/brew/share/postgresql@17/extension/
SELECT * FROM pg_extension;
SELECT * FROM pg_available_extensions;
\dx
\connect your-timescalen-db-name
SELECT extversion FROM pg_extension where extname = 'timescaledb';
Related[edit]
See also[edit]
Advertising: