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