Search PostgreSQL documentation

DescriptionManual ChaptersPG18Description CREATE CAST defines a new cast. A cast specifies how to perform a conversion between two data types. For example, SELECT CAST(42 AS float8); converts the integer constant 42 to t…Description DescriptionManual ChaptersPG18Description CREATE COLLATION defines a new collation using the specified operating system locale settings, or by copying an existing collation. To be able to create a collation, you must hav…Description DescriptionManual ChaptersPG18Description CREATE CONVERSION defines a new conversion between two character set encodings. Conversions that are marked DEFAULT can be used for automatic encoding conversion between client a…Description DescriptionManual ChaptersPG18Description CREATE DATABASE creates a new PostgreSQL database. To create a database, you must be a superuser or have the special CREATEDB privilege. See CREATE ROLE. By default, the new data…Description DescriptionManual ChaptersPG18Description CREATE DOMAIN creates a new domain. A domain is essentially a data type with optional constraints (restrictions on the allowed set of values). The user who defines a domain becom…Description DescriptionManual ChaptersPG18Description CREATE EVENT TRIGGER creates a new event trigger. Whenever the designated event occurs and the WHEN condition associated with the trigger, if any, is satisfied, the trigger funct…Description DescriptionManual ChaptersPG18Description CREATE EXTENSION loads a new extension into the current database. There must not be an extension of the same name already loaded. Loading an extension essentially amounts to runn…Description DescriptionManual ChaptersPG18Description CREATE FOREIGN DATA WRAPPER creates a new foreign-data wrapper. The user who defines a foreign-data wrapper becomes its owner. The foreign-data wrapper name must be unique within…Description DescriptionManual ChaptersPG18Description CREATE FOREIGN TABLE creates a new foreign table in the current database. The table will be owned by the user issuing the command. If a schema name is given (for example, CREATE …Description DescriptionManual ChaptersPG18Description CREATE FUNCTION defines a new function. CREATE OR REPLACE FUNCTION will either create a new function, or replace an existing definition. To be able to define a function, the user…Description DescriptionManual ChaptersPG18Description CREATE GROUP is now an alias for CREATE ROLE.Description DescriptionManual ChaptersPG18Description CREATE INDEX constructs an index on the specified column(s) of the specified relation, which can be a table or a materialized view. Indexes are primarily used to enhance database…Description DescriptionManual ChaptersPG18Description CREATE LANGUAGE registers a new procedural language with a PostgreSQL database. Subsequently, functions and procedures can be defined in this new language. CREATE LANGUAGE effect…Description DescriptionManual ChaptersPG18Description CREATE MATERIALIZED VIEW defines a materialized view of a query. The query is executed and used to populate the view at the time the command is issued (unless WITH NO DATA is use…Description DescriptionManual ChaptersPG18Description CREATE OPERATOR CLASS creates a new operator class. An operator class defines how a particular data type can be used with an index. The operator class specifies that certain oper…Description DescriptionManual ChaptersPG18Description CREATE OPERATOR defines a new operator, name. The user who defines an operator becomes its owner. If a schema name is given then the operator is created in the specified schema. …Description DescriptionManual ChaptersPG18Description CREATE OPERATOR FAMILY creates a new operator family. An operator family defines a collection of related operator classes, and perhaps some additional operators and support funct…Description DescriptionManual ChaptersPG18Description The CREATE POLICY command defines a new row-level security policy for a table. Note that row-level security must be enabled on the table (using ALTER TABLE ... ENABLE ROW LEVEL S…Description DescriptionManual ChaptersPG18Description CREATE PROCEDURE defines a new procedure. CREATE OR REPLACE PROCEDURE will either create a new procedure, or replace an existing definition. To be able to define a procedure, the…Description DescriptionManual ChaptersPG18Description CREATE PUBLICATION adds a new publication into the current database. The publication name must be distinct from the name of any existing publication in the current database. A pu…Description DescriptionManual ChaptersPG18Description CREATE ROLE adds a new role to a PostgreSQL database cluster. A role is an entity that can own database objects and have database privileges; a role can be considered a “user”, a…Description DescriptionManual ChaptersPG18Description CREATE RULE defines a new rule applying to a specified table or view. CREATE OR REPLACE RULE will either create a new rule, or replace an existing rule of the same name for the s…Description DescriptionManual ChaptersPG18Description CREATE SCHEMA enters a new schema into the current database. The schema name must be distinct from the name of any existing schema in the current database. A schema is essentiall…Description DescriptionManual ChaptersPG18Description CREATE SEQUENCE creates a new sequence number generator. This involves creating and initializing a new special single-row table with the name name. The generator will be owned by…Description DescriptionManual ChaptersPG18Description CREATE SERVER defines a new foreign server. The user who defines the server becomes its owner. A foreign server typically encapsulates connection information that a foreign-data …Description DescriptionManual ChaptersPG18Description CREATE STATISTICS will create a new extended statistics object tracking data about the specified table, foreign table or materialized view. The statistics object will be created …Description DescriptionManual ChaptersPG18Description CREATE SUBSCRIPTION adds a new logical-replication subscription. The user that creates a subscription becomes the owner of the subscription. The subscription name must be distinc…Description DescriptionManual ChaptersPG18Description CREATE TABLE will create a new, initially empty table in the current database. The table will be owned by the user issuing the command. If a schema name is given (for example, CR…Description DescriptionManual ChaptersPG18Description CREATE TABLE AS creates a table and fills it with data computed by a SELECT command. The table columns have the names and data types associated with the output columns of the SEL…Description DescriptionManual ChaptersPG18Description CREATE TABLESPACE registers a new cluster-wide tablespace. The tablespace name must be distinct from the name of any existing tablespace in the database cluster. A tablespace all…Description DescriptionManual ChaptersPG18Description CREATE TRANSFORM defines a new transform. CREATE OR REPLACE TRANSFORM will either create a new transform, or replace an existing definition. A transform specifies how to adapt a …Description DescriptionManual ChaptersPG18Description CREATE TRIGGER creates a new trigger. CREATE OR REPLACE TRIGGER will either create a new trigger, or replace an existing trigger. The trigger will be associated with the specifie…Description DescriptionManual ChaptersPG18Description CREATE TEXT SEARCH CONFIGURATION creates a new text search configuration. A text search configuration specifies a text search parser that can divide a string into tokens, plus di…Description DescriptionManual ChaptersPG18Description CREATE TEXT SEARCH DICTIONARY creates a new text search dictionary. A text search dictionary specifies a way of recognizing interesting or uninteresting words for searching. A di…Description DescriptionManual ChaptersPG18Description CREATE TEXT SEARCH PARSER creates a new text search parser. A text search parser defines a method for splitting a text string into tokens and assigning types (categories) to the …Description DescriptionManual ChaptersPG18Description CREATE TEXT SEARCH TEMPLATE creates a new text search template. Text search templates define the functions that implement text search dictionaries. A template is not useful by it…Description DescriptionManual ChaptersPG18Description CREATE TYPE registers a new data type for use in the current database. The user who defines a type becomes its owner. If a schema name is given then the type is created in the sp…Description DescriptionManual ChaptersPG18Description CREATE USER is now an alias for CREATE ROLE. The only difference is that when the command is spelled CREATE USER, LOGIN is assumed by default, whereas NOLOGIN is assumed when the…Description DescriptionManual ChaptersPG18Description CREATE USER MAPPING defines a mapping of a user to a foreign server. A user mapping typically encapsulates connection information that a foreign-data wrapper uses together with t…Description DescriptionManual ChaptersPG18Description CREATE VIEW defines a view of a query. The view is not physically materialized. Instead, the query is run every time the view is referenced in a query. CREATE OR REPLACE VIEW is …Description