Search PostgreSQL documentation

CREATE PROCEDURESQL CommandsReferenceCREATE PROCEDURE Functions & Procedures 11 define a new procedure CREATE [ OR REPLACE ] PROCEDURE name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) { LANG…SQL Commands · Functions & Procedures CREATE PROPERTY GRAPHSQL CommandsReferenceCREATE PROPERTY GRAPH Other Objects 19 define a new SQL-property graph CREATE [ TEMP | TEMPORARY ] PROPERTY GRAPH name [ {VERTEX|NODE} TABLES ( vertex_table_definition [, ...] ) ] [ {EDGE|RE…SQL Commands · Other Objects CREATE PUBLICATIONManual ChaptersPG18CREATE PUBLICATION CREATE PUBLICATION — define a new publication Synopsis CREATE PUBLICATION name [ FOR ALL TABLES | FOR publication_object [, ... ] ] [ WITH ( publication_parameter [= value…CREATE PUBLICATION CREATE PUBLICATIONSQL CommandsReferenceCREATE PUBLICATION Logical Replication 10 define a new publication CREATE PUBLICATION name [ FOR TABLE [ ONLY ] table_name [ * ] [, ...] | FOR ALL TABLES ] [ WITH ( publication_parameter [= …SQL Commands · Logical Replication CREATE ROLEManual ChaptersPG18CREATE ROLE CREATE ROLE — define a new database role Synopsis CREATE ROLE name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE |…CREATE ROLE CREATE ROLESQL CommandsReferenceCREATE ROLE Roles & Privileges 10 define a new database role CREATE ROLE name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE …SQL Commands · Roles & Privileges CREATE RULEManual ChaptersPG18CREATE RULE CREATE RULE — define a new rewrite rule Synopsis CREATE [ OR REPLACE ] RULE name AS ON event TO table_name [ WHERE condition ] DO [ ALSO | INSTEAD ] { NOTHING | command | ( comma…CREATE RULE CREATE RULESQL CommandsReferenceCREATE RULE Triggers & Rules 10 define a new rewrite rule CREATE [ OR REPLACE ] RULE name AS ON event TO table_name [ WHERE condition ] DO [ ALSO | INSTEAD ] { NOTHING | command | ( command …SQL Commands · Triggers & Rules CREATE SCHEMAManual ChaptersPG18CREATE SCHEMA CREATE SCHEMA — define a new schema Synopsis CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ ... ] ] CREATE SCHEMA AUTHORIZATION role_specific…CREATE SCHEMA CREATE SCHEMASQL CommandsReferenceCREATE SCHEMA Databases & Schemas 10 define a new schema CREATE SCHEMA schema_name [ AUTHORIZATION role_specification ] [ schema_element [ ... ] ] CREATE SCHEMA AUTHORIZATION role_specificat…SQL Commands · Databases & Schemas CREATE SEQUENCEManual ChaptersPG18CREATE SEQUENCE CREATE SEQUENCE — define a new sequence generator Synopsis CREATE [ { TEMPORARY | TEMP } | UNLOGGED ] SEQUENCE [ IF NOT EXISTS ] name [ AS data_type ] [ INCREMENT [ BY ] incr…CREATE SEQUENCE CREATE SEQUENCESQL CommandsReferenceCREATE SEQUENCE Tables & Views 10 define a new sequence generator CREATE [ TEMPORARY | TEMP ] SEQUENCE [ IF NOT EXISTS ] name [ AS data_type ] [ INCREMENT [ BY ] increment ] [ MINVALUE minva…SQL Commands · Tables & Views CREATE SERVERManual ChaptersPG18CREATE SERVER CREATE SERVER — define a new foreign server Synopsis CREATE SERVER [ IF NOT EXISTS ] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ] FOREIGN DATA WRAPPER fdw_na…CREATE SERVER CREATE SERVERSQL CommandsReferenceCREATE SERVER Foreign Data 10 define a new foreign server CREATE SERVER [IF NOT EXISTS] server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ] FOREIGN DATA WRAPPER fdw_name [ OPTION…SQL Commands · Foreign Data CREATE STATISTICSManual ChaptersPG18CREATE STATISTICS CREATE STATISTICS — define extended statistics Synopsis CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ] ON ( expression ) FROM table_name CREATE STATISTICS [ [ IF N…CREATE STATISTICS CREATE STATISTICSSQL CommandsReferenceCREATE STATISTICS Indexes & Statistics 10 define extended statistics CREATE STATISTICS [ IF NOT EXISTS ] statistics_name [ ( statistics_kind [, ... ] ) ] ON column_name, column_name [, ...] …SQL Commands · Indexes & Statistics CREATE SUBSCRIPTIONManual ChaptersPG18CREATE SUBSCRIPTION CREATE SUBSCRIPTION — define a new subscription Synopsis CREATE SUBSCRIPTION subscription_name CONNECTION 'conninfo' PUBLICATION publication_name [, ...] [ WITH ( subscri…CREATE SUBSCRIPTION CREATE SUBSCRIPTIONSQL CommandsReferenceCREATE SUBSCRIPTION Logical Replication 10 define a new subscription CREATE SUBSCRIPTION subscription_name CONNECTION 'conninfo' PUBLICATION publication_name [, ...] [ WITH ( subscription_pa…SQL Commands · Logical Replication CREATE TABLEManual ChaptersPG18CREATE TABLE CREATE TABLE — define a new table Synopsis CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [ { column_name data_type [ STORAGE…CREATE TABLE CREATE TABLE ASManual ChaptersPG18CREATE TABLE AS CREATE TABLE AS — define a new table from the results of a query Synopsis CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name [ (…CREATE TABLE AS CREATE TABLE ASSQL CommandsReferenceCREATE TABLE AS Tables & Views 10 define a new table from the results of a query CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name [ (column_na…SQL Commands · Tables & Views CREATE TABLESPACEManual ChaptersPG18CREATE TABLESPACE CREATE TABLESPACE — define a new tablespace Synopsis CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } ] LOCATION 'direct…CREATE TABLESPACE CREATE TABLESPACESQL CommandsReferenceCREATE TABLESPACE Databases & Schemas 10 define a new tablespace CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_USER | SESSION_USER } ] LOCATION 'directory' [ WITH ( tablesp…SQL Commands · Databases & Schemas CREATE TEXT SEARCH CONFIGURATIONManual ChaptersPG18CREATE TEXT SEARCH CONFIGURATION CREATE TEXT SEARCH CONFIGURATION — define a new text search configuration Synopsis CREATE TEXT SEARCH CONFIGURATION name ( PARSER = parser_name | COPY = sour…CREATE TEXT SEARCH CONFIGURATION CREATE TEXT SEARCH CONFIGURATIONSQL CommandsReferenceCREATE TEXT SEARCH CONFIGURATION Text Search 10 define a new text search configuration CREATE TEXT SEARCH CONFIGURATION name ( PARSER = parser_name | COPY = source_config ) CREATE TEXT SEARC…SQL Commands · Text Search CREATE TEXT SEARCH DICTIONARYManual ChaptersPG18CREATE TEXT SEARCH DICTIONARY CREATE TEXT SEARCH DICTIONARY — define a new text search dictionary Synopsis CREATE TEXT SEARCH DICTIONARY name ( TEMPLATE = template [, option = value [, ... ]…CREATE TEXT SEARCH DICTIONARY CREATE TEXT SEARCH DICTIONARYSQL CommandsReferenceCREATE TEXT SEARCH DICTIONARY Text Search 10 define a new text search dictionary CREATE TEXT SEARCH DICTIONARY name ( TEMPLATE = template [, option = value [, ... ]] ) CREATE TEXT SEARCH DIC…SQL Commands · Text Search CREATE TEXT SEARCH PARSERManual ChaptersPG18CREATE TEXT SEARCH PARSER CREATE TEXT SEARCH PARSER — define a new text search parser Synopsis CREATE TEXT SEARCH PARSER name ( START = start_function , GETTOKEN = gettoken_function , END = …CREATE TEXT SEARCH PARSER CREATE TEXT SEARCH PARSERSQL CommandsReferenceCREATE TEXT SEARCH PARSER Text Search 10 define a new text search parser CREATE TEXT SEARCH PARSER name ( START = start_function , GETTOKEN = gettoken_function , END = end_function , LEXTYPE…SQL Commands · Text Search CREATE TEXT SEARCH TEMPLATEManual ChaptersPG18CREATE TEXT SEARCH TEMPLATE CREATE TEXT SEARCH TEMPLATE — define a new text search template Synopsis CREATE TEXT SEARCH TEMPLATE name ( [ INIT = init_function , ] LEXIZE = lexize_function )CREATE TEXT SEARCH TEMPLATE CREATE TEXT SEARCH TEMPLATESQL CommandsReferenceCREATE TEXT SEARCH TEMPLATE Text Search 10 define a new text search template CREATE TEXT SEARCH TEMPLATE name ( [ INIT = init_function , ] LEXIZE = lexize_function ) CREATE TEXT SEARCH TEMPL…SQL Commands · Text Search CREATE TRANSFORMManual ChaptersPG18CREATE TRANSFORM CREATE TRANSFORM — define a new transform Synopsis CREATE [ OR REPLACE ] TRANSFORM FOR type_name LANGUAGE lang_name ( FROM SQL WITH FUNCTION from_sql_function_name [ (argume…CREATE TRANSFORM CREATE TRANSFORMSQL CommandsReferenceCREATE TRANSFORM Functions & Procedures 10 define a new transform CREATE [ OR REPLACE ] TRANSFORM FOR type_name LANGUAGE lang_name ( FROM SQL WITH FUNCTION from_sql_function_name [ (argument…SQL Commands · Functions & Procedures CREATE TRIGGERManual ChaptersPG18CREATE TRIGGER CREATE TRIGGER — define a new trigger Synopsis CREATE [ OR REPLACE ] [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] } ON table_name [ FROM refe…CREATE TRIGGER CREATE TRIGGERSQL CommandsReferenceCREATE TRIGGER Triggers & Rules 10 define a new trigger CREATE [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] } ON table_name [ FROM referenced_table_name ] […SQL Commands · Triggers & Rules CREATE TYPEManual ChaptersPG18CREATE TYPE CREATE TYPE — define a new data type Synopsis CREATE TYPE name AS ( [ attribute_name data_type [ COLLATE collation ] [, ... ] ] ) CREATE TYPE name AS ENUM ( [ 'label' [, ... ] ] …CREATE TYPE CREATE TYPESQL CommandsReferenceCREATE TYPE Types & Operators 10 define a new data type CREATE TYPE name AS ( [ attribute_name data_type [ COLLATE collation ] [, ... ] ] ) CREATE TYPE name AS ENUM ( [ 'label' [, ... ] ] )…SQL Commands · Types & Operators CREATE USERManual ChaptersPG18CREATE USER CREATE USER — define a new database role Synopsis CREATE USER name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE |…CREATE USER CREATE USERSQL CommandsReferenceCREATE USER Roles & Privileges 10 define a new database role CREATE USER name [ [ WITH ] option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE …SQL Commands · Roles & Privileges CREATE USER MAPPINGManual ChaptersPG18CREATE USER MAPPING CREATE USER MAPPING — define a new mapping of a user to a foreign server Synopsis CREATE USER MAPPING [ IF NOT EXISTS ] FOR { user_name | USER | CURRENT_ROLE | CURRENT_US…CREATE USER MAPPING