Difference between revisions of "PostgreSQL extensions"
Jump to navigation
Jump to search
(Created page with " {{PostgreSQL extensions}}") |
|||
| (12 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[CREATE EXTENSION]] | ||
| + | [[CREATE EXTENSION pg_stat_statements]]; | ||
| − | {{PostgreSQL extensions}} | + | [[List extensions]]: |
| + | * <code>[[SELECT * FROM pg_extension;]]</code> | ||
| + | * <code>SELECT * FROM [[pg_available_extensions]];</code> | ||
| + | |||
| + | |||
| + | <code>[[\connect]] your-timescalen-db-name</code> | ||
| + | |||
| + | <code>SELECT extversion [[FROM]] pg_extension where extname = '[[timescaledb]]';</code> | ||
| + | |||
| + | |||
| + | == Related == | ||
| + | * [[ZomboDB]] | ||
| + | * [[TimescaleDB]] extension | ||
| + | * <code>[[plpgsql]]</code> | ||
| + | * [[Temporal database]] | ||
| + | |||
| + | == See also == | ||
| + | * {{PostgreSQL extensions}} | ||
| + | |||
| + | [[Category:PostgreSQL]] | ||
Latest revision as of 12:23, 28 March 2024
CREATE EXTENSION CREATE EXTENSION pg_stat_statements;
SELECT * FROM pg_extension;SELECT * FROM pg_available_extensions;
\connect your-timescalen-db-name
SELECT extversion FROM pg_extension where extname = 'timescaledb';
Related[edit]
- ZomboDB
- TimescaleDB extension
plpgsql- Temporal database
See also[edit]
Advertising:
