Search PostgreSQL documentation

DescriptionManual ChaptersPG18Description CLUSTER instructs PostgreSQL to cluster the table specified by table_name based on the index specified by index_name. The index must already have been defined on table_name. When…Description DescriptionManual ChaptersPG18Description COMMENT stores, replaces, or removes the comment on a database object. Only one comment string is stored for each object. Issuing a new COMMENT command for the same object replac…Description DescriptionManual ChaptersPG18Description COMMIT PREPARED commits a transaction that is in prepared state.Description DescriptionManual ChaptersPG18Description COMMIT commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs.Description DescriptionManual ChaptersPG18Description COPY moves data between PostgreSQL tables and standard file-system files. COPY TO copies the contents of a table to a file, while COPY FROM copies data from a file to a table (ap…Description DescriptionManual ChaptersPG18Description CREATE ACCESS METHOD creates a new access method. The access method name must be unique within the database. Only superusers can define new access methods.Description DescriptionManual ChaptersPG18Description CREATE AGGREGATE defines a new aggregate function. CREATE OR REPLACE AGGREGATE will either define a new aggregate function or replace an existing definition. Some basic and commo…Description 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