Difference between revisions of "PostgreSQL extensions"
Jump to navigation
Jump to search
Line 7: | Line 7: | ||
* <code>[[SELECT * FROM pg_extension;]]</code> | * <code>[[SELECT * FROM pg_extension;]]</code> | ||
* <code>SELECT * FROM [[pg_available_extensions]];</code> | * <code>SELECT * FROM [[pg_available_extensions]];</code> | ||
+ | * <code>[[\dx]]</code> | ||
Revision as of 15:18, 19 December 2024
CREATE EXTENSION CREATE EXTENSION pg_stat_statements; CREATE EXTENSION uuid-ossp
SELECT * FROM pg_extension;
SELECT * FROM pg_available_extensions;
\dx
\connect your-timescalen-db-name
SELECT extversion FROM pg_extension where extname = 'timescaledb';
Related
See also
Advertising: