Difference between revisions of "CREATE EXTENSION"
Jump to navigation
Jump to search
(4 intermediate revisions by the same user not shown) | |||
Line 10: | Line 10: | ||
== Examples == | == Examples == | ||
* <code>[[CREATE EXTENSION pg_stat_statements]];</code> | * <code>[[CREATE EXTENSION pg_stat_statements]];</code> | ||
− | * <code>create extension | + | * <code>[[create extension pg_trgm;]]</code> |
* <code>create extension [[btree_gist]];</code> | * <code>create extension [[btree_gist]];</code> | ||
* <code>create extension [[postgres_fdw]];</code> | * <code>create extension [[postgres_fdw]];</code> | ||
+ | * <code>[[CREATE EXTENSION uuid-ossp]];</code> | ||
* <code>CREATE EXTENSION [[IF NOT EXISTS]] [[pg_stat_statements]] WITH [[SCHEMA]] public;</code> | * <code>CREATE EXTENSION [[IF NOT EXISTS]] [[pg_stat_statements]] WITH [[SCHEMA]] public;</code> | ||
− | |||
* <code>[[CREATE EXTENSION IF NOT EXISTS timescaledb]];</code> ([[TimescaleDB installation]]) | * <code>[[CREATE EXTENSION IF NOT EXISTS timescaledb]];</code> ([[TimescaleDB installation]]) | ||
+ | |||
+ | |||
+ | create extension WRONG_NAME; | ||
+ | ERROR: extension "wrong_name" is not available | ||
+ | DETAIL: Could not open extension control file "[[/Users/user/brew/share/postgresql@17/extension/]]wrong_name.control": No such | ||
+ | file or directory. | ||
+ | HINT: The extension must first be installed on the system where PostgreSQL is running. | ||
== Related == | == Related == | ||
* [[PostgreSQL extension]]s | * [[PostgreSQL extension]]s | ||
* <code>[[SELECT * FROM pg_extension;]]</code> | * <code>[[SELECT * FROM pg_extension;]]</code> | ||
+ | * [[plpgsql]] | ||
== See also == | == See also == |
Latest revision as of 15:24, 19 December 2024
CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ CASCADE ]
CASCADE
Automatically install any extensions that this extension depends on that are not already installed. Their dependencies are likewise automatically installed, recursively. The SCHEMA clause, if given, applies to all extensions that get installed this way. Other options of the statement are not applied to automatically-installed extensions; in particular, their default versions are always selected.
Examples[edit]
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 WRONG_NAME; ERROR: extension "wrong_name" is not available DETAIL: Could not open extension control file "/Users/user/brew/share/postgresql@17/extension/wrong_name.control": No such file or directory. HINT: The extension must first be installed on the system where PostgreSQL is running.
Related[edit]
See also[edit]
Advertising: