Search PostgreSQL documentation

ParametersManual ChaptersPG18CREATE POLICYname The name of the policy to be created. This must be distinct from the name of any other policy for the table. table_name The name (optionally schema-qualified) of the table the policy ap… ParametersManual ChaptersPG18CREATE PROCEDUREname The name (optionally schema-qualified) of the procedure to create. argmode The mode of an argument: IN, OUT, INOUT, or VARIADIC. If omitted, the default is IN. argname The name of an ar… ParametersManual ChaptersPG18CREATE PUBLICATIONname The name of the new publication. FOR TABLE Specifies a list of tables to add to the publication. If ONLY is specified before the table name, only that table is added to the publication.… ParametersManual ChaptersPG18CREATE ROLEname The name of the new role. SUPERUSERNOSUPERUSER These clauses determine whether the new role is a “superuser”, who can override all access restrictions within the database. Superuser sta… ParametersManual ChaptersPG18CREATE RULEname The name of a rule to create. This must be distinct from the name of any other rule for the same table. Multiple rules on the same table and same event type are applied in alphabetical … ParametersManual ChaptersPG18CREATE SCHEMAschema_name The name of a schema to be created. If this is omitted, the user_name is used as the schema name. The name cannot begin with pg_, as such names are reserved for system schemas. u… ParametersManual ChaptersPG18CREATE SEQUENCETEMPORARY or TEMP If specified, the sequence object is created only for this session, and is automatically dropped on session exit. Existing permanent sequences with the same name are not vi… ParametersManual ChaptersPG18CREATE SERVERIF NOT EXISTS Do not throw an error if a server with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing server is anything like … ParametersManual ChaptersPG18CREATE STATISTICSIF NOT EXISTS Do not throw an error if a statistics object with the same name already exists. A notice is issued in this case. Note that only the name of the statistics object is considered … ParametersManual ChaptersPG18CREATE SUBSCRIPTIONsubscription_name The name of the new subscription. CONNECTION 'conninfo' The libpq connection string defining how to connect to the publisher database. For details see Section 32.1.1. PUBLI… ParametersManual ChaptersPG18CREATE TABLETEMPORARY or TEMP If specified, the table is created as a temporary table. Temporary tables are automatically dropped at the end of a session, or optionally at the end of the current transac… ParametersManual ChaptersPG18CREATE TABLE ASGLOBAL or LOCAL Ignored for compatibility. Use of these keywords is deprecated; refer to CREATE TABLE for details. TEMPORARY or TEMP If specified, the table is created as a temporary table. … ParametersManual ChaptersPG18CREATE TABLESPACEtablespace_name The name of a tablespace to be created. The name cannot begin with pg_, as such names are reserved for system tablespaces. user_name The name of the user who will own the tab… ParametersManual ChaptersPG18CREATE TRANSFORMtype_name The name of the data type of the transform. lang_name The name of the language of the transform. from_sql_function_name[(argument_type [, ...])] The name of the function for conver… ParametersManual ChaptersPG18CREATE TRIGGERname The name to give the new trigger. This must be distinct from the name of any other trigger for the same table. The name cannot be schema-qualified — the trigger inherits the schema of i… ParametersManual ChaptersPG18CREATE TEXT SEARCH CONFIGURATIONname The name of the text search configuration to be created. The name can be schema-qualified. parser_name The name of the text search parser to use for this configuration. source_config Th… ParametersManual ChaptersPG18CREATE TEXT SEARCH DICTIONARYname The name of the text search dictionary to be created. The name can be schema-qualified. template The name of the text search template that will define the basic behavior of this diction… ParametersManual ChaptersPG18CREATE TEXT SEARCH PARSERname The name of the text search parser to be created. The name can be schema-qualified. start_function The name of the start function for the parser. gettoken_function The name of the get-n… ParametersManual ChaptersPG18CREATE TEXT SEARCH TEMPLATEname The name of the text search template to be created. The name can be schema-qualified. init_function The name of the init function for the template. lexize_function The name of the lexiz… ParametersManual ChaptersPG18CREATE TYPEname The name (optionally schema-qualified) of a type to be created. attribute_name The name of an attribute (column) for the composite type. data_type The name of an existing data type to b… ParametersManual ChaptersPG18CREATE USER MAPPINGIF NOT EXISTS Do not throw an error if a mapping of the given user to the given foreign server already exists. A notice is issued in this case. Note that there is no guarantee that the exist… ParametersManual ChaptersPG18CREATE VIEWTEMPORARY or TEMP If specified, the view is created as a temporary view. Temporary views are automatically dropped at the end of the current session. Existing permanent relations with the sa… ParametersManual ChaptersPG18DEALLOCATEPREPARE This key word is ignored. name The name of the prepared statement to deallocate. ALL Deallocate all prepared statements. ParametersManual ChaptersPG18DECLAREname The name of the cursor to be created. This must be different from any other active cursor name in the session. BINARY Causes the cursor to return data in binary rather than in text form… ParametersManual ChaptersPG18DELETEwith_query The WITH clause allows you to specify one or more subqueries that can be referenced by name in the DELETE query. See Section 7.8 and SELECT for details. table_name The name (optio… ParametersManual ChaptersPG18DISCARDPLANS Releases all cached query plans, forcing re-planning to occur the next time the associated prepared statement is used. SEQUENCES Discards all cached sequence-related state, including c… ParametersManual ChaptersPG18DOcode The procedural language code to be executed. This must be specified as a string literal, just as in CREATE FUNCTION. Use of a dollar-quoted literal is recommended. lang_name The name of… ParametersManual ChaptersPG18DROP ACCESS METHODIF EXISTS Do not throw an error if the access method does not exist. A notice is issued in this case. name The name of an existing access method. CASCADE Automatically drop objects that depe… ParametersManual ChaptersPG18DROP OWNEDname The name of a role whose objects will be dropped, and whose privileges will be revoked. CASCADE Automatically drop objects that depend on the affected objects, and in turn all objects t… ParametersManual ChaptersPG18DROP AGGREGATEIF EXISTS Do not throw an error if the aggregate does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing aggregate function. argmode The m… ParametersManual ChaptersPG18DROP CASTIF EXISTS Do not throw an error if the cast does not exist. A notice is issued in this case. source_type The name of the source data type of the cast. target_type The name of the target data… ParametersManual ChaptersPG18DROP COLLATIONIF EXISTS Do not throw an error if the collation does not exist. A notice is issued in this case. name The name of the collation. The collation name can be schema-qualified. CASCADE Automati… ParametersManual ChaptersPG18DROP CONVERSIONIF EXISTS Do not throw an error if the conversion does not exist. A notice is issued in this case. name The name of the conversion. The conversion name can be schema-qualified. CASCADERESTRI… ParametersManual ChaptersPG18DROP DATABASEIF EXISTS Do not throw an error if the database does not exist. A notice is issued in this case. name The name of the database to remove. FORCE Attempt to terminate all existing connections … ParametersManual ChaptersPG18DROP DOMAINIF EXISTS Do not throw an error if the domain does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing domain. CASCADE Automatically drop o… ParametersManual ChaptersPG18DROP EVENT TRIGGERIF EXISTS Do not throw an error if the event trigger does not exist. A notice is issued in this case. name The name of the event trigger to remove. CASCADE Automatically drop objects that de… ParametersManual ChaptersPG18DROP EXTENSIONIF EXISTS Do not throw an error if the extension does not exist. A notice is issued in this case. name The name of an installed extension. CASCADE Automatically drop objects that depend on t… ParametersManual ChaptersPG18DROP FOREIGN DATA WRAPPERIF EXISTS Do not throw an error if the foreign-data wrapper does not exist. A notice is issued in this case. name The name of an existing foreign-data wrapper. CASCADE Automatically drop obj… ParametersManual ChaptersPG18DROP FOREIGN TABLEIF EXISTS Do not throw an error if the foreign table does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the foreign table to drop. CASCADE Automa… ParametersManual ChaptersPG18DROP FUNCTIONIF EXISTS Do not throw an error if the function does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing function. If no argument list is s…