Difference between revisions of "CREATE EXTENSION"

Revision as of 05:57, 25 October 2022

CREATE EXTENSION [ IF NOT EXISTS ] extension_name
   [ WITH ] [ SCHEMA schema_name ]
            [ VERSION version ]
            [ CASCADE ]

CREATE EXTENSION pg_stat_statements;
CREATE EXTENSION IF NOT EXISTS pg_stat_statements WITH SCHEMA public;

CREATE EXTENSION uuid-ossp;

Revision as of 05:56, 25 October 2022 (edit) Welcome (talk \| contribs) (→‎Related) ← Older edit		Revision as of 05:57, 25 October 2022 (edit) (undo) Welcome (talk \| contribs) Newer edit →
Line 7:		Line 7:


−	[[CREATE]] EXTENSION [[pg_stat_statements]];	+	[[CREATE EXTENSION pg_stat_statements]];
	CREATE EXTENSION [[IF NOT EXISTS]] [[pg_stat_statements]] WITH [[SCHEMA]] public;		CREATE EXTENSION [[IF NOT EXISTS]] [[pg_stat_statements]] WITH [[SCHEMA]] public;