Difference between revisions of "CREATE EXTENSION"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
[ CASCADE ] | [ CASCADE ] | ||
| − | + | == Example == | |
| − | + | * <code>[[CREATE EXTENSION pg_stat_statements]];</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]] [[timescaledb]];</code> | ||
Revision as of 07:31, 1 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 timescaledb;
Related
See also
Advertising:
