Search PostgreSQL documentation

CREATE ACCESS METHODManual ChaptersPG18CREATE ACCESS METHOD CREATE ACCESS METHOD — define a new access method Synopsis CREATE ACCESS METHOD name TYPE access_method_type HANDLER handler_functionCREATE ACCESS METHOD 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 FAMILYManual ChaptersPG18CREATE OPERATOR FAMILY CREATE OPERATOR FAMILY — define a new operator family Synopsis CREATE OPERATOR FAMILY name USING index_methodCREATE OPERATOR FAMILY 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 PROCEDUREManual ChaptersPG18CREATE PROCEDURE CREATE PROCEDURE — define a new procedure Synopsis CREATE [ OR REPLACE ] PROCEDURE name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] ) { LA…CREATE PROCEDURE 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 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 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 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 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 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 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 SUBSCRIPTIONManual ChaptersPG18CREATE SUBSCRIPTION CREATE SUBSCRIPTION — define a new subscription Synopsis CREATE SUBSCRIPTION subscription_name CONNECTION 'conninfo' PUBLICATION publication_name [, ...] [ WITH ( subscri…CREATE SUBSCRIPTION 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 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 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 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 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 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 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 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 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