Difference between revisions of "PostgreSQL extensions"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
[[CREATE EXTENSION]] | [[CREATE EXTENSION]] | ||
[[CREATE EXTENSION pg_stat_statements]]; | [[CREATE EXTENSION pg_stat_statements]]; | ||
[[CREATE EXTENSION]] [[uuid-ossp]] | [[CREATE EXTENSION]] [[uuid-ossp]] | ||
| + | * List available extensions: [[~/brew/share/postgresql@17/extension/]] | ||
[[List extensions]]: | [[List extensions]]: | ||
* <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> | ||
| Line 21: | Line 21: | ||
* <code>[[plpgsql]]</code> | * <code>[[plpgsql]]</code> | ||
* [[Temporal database]] | * [[Temporal database]] | ||
| + | * [[brew install postgresql]] | ||
== See also == | == See also == | ||
Latest revision as of 15:30, 19 December 2024
CREATE EXTENSION CREATE EXTENSION pg_stat_statements; CREATE EXTENSION uuid-ossp
- 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:
