Search PostgreSQL documentation

CREATE AGGREGATEManual ChaptersPG18CREATE AGGREGATE CREATE AGGREGATE — define a new aggregate function Synopsis CREATE [ OR REPLACE ] AGGREGATE name ( [ argmode ] [ argname ] arg_data_type [ , ... ] ) ( SFUNC = sfunc, STYPE =…CREATE AGGREGATE CREATE AGGREGATESQL CommandsReferenceCREATE AGGREGATE Functions & Procedures 10 define a new aggregate function CREATE AGGREGATE name ( [ argmode ] [ argname ] arg_data_type [ , ... ] ) ( SFUNC = sfunc, STYPE = state_data_type …SQL Commands · Functions & Procedures CREATE CASTManual ChaptersPG18CREATE CAST CREATE CAST — define a new cast Synopsis CREATE CAST (source_type AS target_type) WITH FUNCTION function_name [ (argument_type [, ...]) ] [ AS ASSIGNMENT | AS IMPLICIT ] CREATE C…CREATE CAST CREATE CASTSQL CommandsReferenceCREATE CAST Types & Operators 10 define a new cast CREATE CAST (source_type AS target_type) WITH FUNCTION function_name [ (argument_type [, ...]) ] [ AS ASSIGNMENT | AS IMPLICIT ] CREATE CA…SQL Commands · Types & Operators CREATE COLLATIONManual ChaptersPG18CREATE COLLATION CREATE COLLATION — define a new collation Synopsis CREATE COLLATION [ IF NOT EXISTS ] name ( [ LOCALE = locale, ] [ LC_COLLATE = lc_collate, ] [ LC_CTYPE = lc_ctype, ] [ PRO…CREATE COLLATION CREATE COLLATIONSQL CommandsReferenceCREATE COLLATION Types & Operators 10 define a new collation CREATE COLLATION [ IF NOT EXISTS ] name ( [ LOCALE = locale, ] [ LC_COLLATE = lc_collate, ] [ LC_CTYPE = lc_ctype, ] [ PROVIDER =…SQL Commands · Types & Operators CREATE CONVERSIONManual ChaptersPG18CREATE CONVERSION CREATE CONVERSION — define a new encoding conversion Synopsis CREATE [ DEFAULT ] CONVERSION name FOR source_encoding TO dest_encoding FROM function_nameCREATE CONVERSION CREATE CONVERSIONSQL CommandsReferenceCREATE CONVERSION Types & Operators 10 define a new encoding conversion CREATE [ DEFAULT ] CONVERSION name FOR source_encoding TO dest_encoding FROM function_name CREATE CONVERSION defines a…SQL Commands · Types & Operators CREATE DATABASEManual ChaptersPG18CREATE DATABASE CREATE DATABASE — create a new database Synopsis CREATE DATABASE name [ WITH ] [ OWNER [=] user_name ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] [ STRATEGY [=] stra…CREATE DATABASE CREATE DATABASESQL CommandsReferenceCREATE DATABASE Databases & Schemas 10 create a new database CREATE DATABASE name [ WITH ] [ OWNER [=] user_name ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] [ LC_COLLATE [=] lc_col…SQL Commands · Databases & Schemas CREATE DOMAINManual ChaptersPG18CREATE DOMAIN CREATE DOMAIN — define a new domain Synopsis CREATE DOMAIN name [ AS ] data_type [ COLLATE collation ] [ DEFAULT expression ] [ domain_constraint [ ... ] ] where domain_constra…CREATE DOMAIN CREATE DOMAINSQL CommandsReferenceCREATE DOMAIN Types & Operators 10 define a new domain CREATE DOMAIN name [ AS ] data_type [ COLLATE collation ] [ DEFAULT expression ] [ constraint [ ... ] ] where constraint is: [ CONSTR…SQL Commands · Types & Operators CREATE EVENT TRIGGERManual ChaptersPG18CREATE EVENT TRIGGER CREATE EVENT TRIGGER — define a new event trigger Synopsis CREATE EVENT TRIGGER name ON event [ WHEN filter_variable IN (filter_value [, ... ]) [ AND ... ] ] EXECUTE { F…CREATE EVENT TRIGGER CREATE EVENT TRIGGERSQL CommandsReferenceCREATE EVENT TRIGGER Triggers & Rules 10 define a new event trigger CREATE EVENT TRIGGER name ON event [ WHEN filter_variable IN (filter_value [, ... ]) [ AND ... ] ] EXECUTE PROCEDURE funct…SQL Commands · Triggers & Rules CREATE EXTENSIONManual ChaptersPG18CREATE EXTENSION CREATE EXTENSION — install an extension Synopsis CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ CASCADE ]CREATE EXTENSION CREATE EXTENSIONSQL CommandsReferenceCREATE EXTENSION Extensions & Access Methods 10 install an extension CREATE EXTENSION [ IF NOT EXISTS ] extension_name [ WITH ] [ SCHEMA schema_name ] [ VERSION version ] [ FROM old_version …SQL Commands · Extensions & Access Methods CREATE FOREIGN DATA WRAPPERManual ChaptersPG18CREATE FOREIGN DATA WRAPPER CREATE FOREIGN DATA WRAPPER — define a new foreign-data wrapper Synopsis CREATE FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HANDLER ] [ VALIDATOR va…CREATE FOREIGN DATA WRAPPER CREATE FOREIGN DATA WRAPPERSQL CommandsReferenceCREATE FOREIGN DATA WRAPPER Foreign Data 10 define a new foreign-data wrapper CREATE FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HANDLER ] [ VALIDATOR validator_function | NO V…SQL Commands · Foreign Data CREATE FOREIGN TABLEManual ChaptersPG18CREATE FOREIGN TABLE CREATE FOREIGN TABLE — define a new foreign table Synopsis CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ OPTIONS ( option 'value' [, ..…CREATE FOREIGN TABLE CREATE FOREIGN TABLESQL CommandsReferenceCREATE FOREIGN TABLE Foreign Data 10 define a new foreign table CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ OPTIONS ( option 'value' [, ... ] ) ] [ COLLAT…SQL Commands · Foreign Data CREATE FUNCTIONManual ChaptersPG18CREATE FUNCTION CREATE FUNCTION — define a new function Synopsis CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) [ RETURN…CREATE FUNCTION CREATE FUNCTIONSQL CommandsReferenceCREATE FUNCTION Functions & Procedures 10 define a new function CREATE [ OR REPLACE ] FUNCTION name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) [ RETURNS…SQL Commands · Functions & Procedures CREATE GROUPManual ChaptersPG18CREATE GROUP CREATE GROUP — define a new database role Synopsis CREATE GROUP name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROL…CREATE GROUP CREATE GROUPSQL CommandsReferenceCREATE GROUP Roles & Privileges 10 define a new database role CREATE GROUP name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROL…SQL Commands · Roles & Privileges CREATE INDEXManual ChaptersPG18CREATE INDEX CREATE INDEX — define a new index Synopsis CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON [ ONLY ] table_name [ USING method ] ( { column_name | ( expres…CREATE INDEX CREATE INDEXSQL CommandsReferenceCREATE INDEX Indexes & Statistics 10 define a new index CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON table_name [ USING method ] ( { column_name | ( expression ) } …SQL Commands · Indexes & Statistics CREATE INDEX Progress ReportingManual ChaptersPG1827.4.4. CREATE INDEX Progress Reporting Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating i…CREATE INDEX Progress Reporting CREATE LANGUAGEManual ChaptersPG18CREATE LANGUAGE CREATE LANGUAGE — define a new procedural language Synopsis CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name HANDLER call_handler [ INLINE inline_handler ] [ VA…CREATE LANGUAGE CREATE LANGUAGESQL CommandsReferenceCREATE LANGUAGE Functions & Procedures 10 define a new procedural language CREATE [ OR REPLACE ] [ PROCEDURAL ] LANGUAGE name CREATE [ OR REPLACE ] [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name H…SQL Commands · Functions & Procedures CREATE MATERIALIZED VIEWManual ChaptersPG18CREATE MATERIALIZED VIEW CREATE MATERIALIZED VIEW — define a new materialized view Synopsis CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] table_name [ (column_name [, ...] ) ] [ USING method ] …CREATE MATERIALIZED VIEW CREATE MATERIALIZED VIEWSQL CommandsReferenceCREATE MATERIALIZED VIEW Tables & Views 10 define a new materialized view CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] table_name [ (column_name [, ...] ) ] [ WITH ( storage_parameter [= value…SQL Commands · Tables & Views CREATE OPERATORManual ChaptersPG18CREATE OPERATOR CREATE OPERATOR — define a new operator Synopsis CREATE OPERATOR name ( {FUNCTION|PROCEDURE} = function_name [, LEFTARG = left_type ] [, RIGHTARG = right_type ] [, COMMUTATOR…CREATE OPERATOR CREATE OPERATORSQL CommandsReferenceCREATE OPERATOR Types & Operators 10 define a new operator CREATE OPERATOR name ( PROCEDURE = function_name [, LEFTARG = left_type ] [, RIGHTARG = right_type ] [, COMMUTATOR = com_op ] [, NE…SQL Commands · Types & Operators CREATE OPERATOR CLASSManual ChaptersPG18CREATE OPERATOR CLASS CREATE OPERATOR CLASS — define a new operator class Synopsis CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method [ FAMILY family_name ] AS { OP…CREATE OPERATOR CLASS CREATE OPERATOR CLASSSQL CommandsReferenceCREATE OPERATOR CLASS Types & Operators 10 define a new operator class CREATE OPERATOR CLASS name [ DEFAULT ] FOR TYPE data_type USING index_method [ FAMILY family_name ] AS { OPERATOR strat…SQL Commands · Types & Operators CREATE OPERATOR FAMILYManual ChaptersPG18CREATE OPERATOR FAMILY CREATE OPERATOR FAMILY — define a new operator family Synopsis CREATE OPERATOR FAMILY name USING index_methodCREATE OPERATOR FAMILY CREATE OPERATOR FAMILYSQL CommandsReferenceCREATE OPERATOR FAMILY Types & Operators 10 define a new operator family CREATE OPERATOR FAMILY name USING index_method CREATE OPERATOR FAMILY creates a new operator family. An operator fami…SQL Commands · Types & Operators CREATE POLICYManual ChaptersPG18CREATE POLICY CREATE POLICY — define a new row-level security policy for a table Synopsis CREATE POLICY name ON table_name [ AS { PERMISSIVE | RESTRICTIVE } ] [ FOR { ALL | SELECT | INSERT |…CREATE POLICY CREATE POLICYSQL CommandsReferenceCREATE POLICY Roles & Privileges 10 define a new row level security policy for a table CREATE POLICY name ON table_name [ AS { PERMISSIVE | RESTRICTIVE } ] [ FOR { ALL | SELECT | INSERT | UP…SQL Commands · Roles & Privileges CREATE PROCEDUREManual ChaptersPG18CREATE PROCEDURE CREATE PROCEDURE — define a new procedure Synopsis CREATE [ OR REPLACE ] PROCEDURE name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) { LA…CREATE PROCEDURE