Difference between revisions of "CREATE EXTENSION"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
[ CASCADE ] | [ CASCADE ] | ||
| − | == | + | == Examples == |
* <code>[[CREATE EXTENSION pg_stat_statements]];</code> | * <code>[[CREATE EXTENSION pg_stat_statements]];</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 uuid-ossp]];</code> | * <code>[[CREATE EXTENSION uuid-ossp]];</code> | ||
| − | * <code>[[CREATE EXTENSION]] IF NOT EXISTS [[timescaledb]];</code> | + | * [[TimescaleDB installation]]: <code>[[CREATE EXTENSION]] IF NOT EXISTS [[timescaledb]];</code> |
== Related == | == Related == | ||
Revision as of 16:10, 2 February 2023
CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ CASCADE ]
Examples
CREATE EXTENSION pg_stat_statements;CREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public;CREATE EXTENSION uuid-ossp;- TimescaleDB installation:
CREATE EXTENSION IF NOT EXISTS timescaledb;
Related
See also
Advertising:
