Difference between revisions of "CREATE EXTENSION"

Latest revision as of 07:39, 13 July 2023

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.

@@ Line 6: / Line 6: @@
               [ CASCADE ]
+* <code>CASCADE</code> 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.
- [[CREATE]] EXTENSION [[pg_stat_statements]];
+== Examples ==
- CREATE EXTENSION [[IF NOT EXISTS]] [[pg_stat_statements]] WITH [[SCHEMA]] public;
+* <code>[[CREATE EXTENSION pg_stat_statements]];</code>
+* <code>create extension [[pg_trgm]];</code>
- CREATE EXTENSION [[uuid-ossp]];
+* <code>create extension [[btree_gist]];</code>
+* <code>create extension [[postgres_fdw]];</code>
+* <code>CREATE EXTENSION [[IF NOT EXISTS]] [[pg_stat_statements]] WITH [[SCHEMA]] public;</code>
+* <code>[[CREATE EXTENSION uuid-ossp]];</code>
+* <code>[[CREATE EXTENSION IF NOT EXISTS timescaledb]];</code> ([[TimescaleDB installation]])
 == Related ==
 * [[PostgreSQL extension]]s
+* <code>[[SELECT * FROM pg_extension;]]</code>
 == See also ==