Search PostgreSQL documentation

ParametersManual ChaptersPG18Parameters TEMPORARY 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…Parameters ParametersManual ChaptersPG18Parameters IF 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 any…Parameters ParametersManual ChaptersPG18Parameters IF 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 …Parameters ParametersManual ChaptersPG18Parameters subscription_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…Parameters ParametersManual ChaptersPG18Parameters TEMPORARY 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 curr…Parameters ParametersManual ChaptersPG18Parameters GLOBAL 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 tempor…Parameters ParametersManual ChaptersPG18Parameters tablespace_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 …Parameters ParametersManual ChaptersPG18Parameters type_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…Parameters ParametersManual ChaptersPG18Parameters name 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 …Parameters ParametersManual ChaptersPG18Parameters name 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. sourc…Parameters ParametersManual ChaptersPG18Parameters name 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 t…Parameters ParametersManual ChaptersPG18Parameters name 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 o…Parameters ParametersManual ChaptersPG18Parameters name 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 o…Parameters ParametersManual ChaptersPG18Parameters name 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 dat…Parameters ParametersManual ChaptersPG18Parameters IF 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 tha…Parameters ParametersManual ChaptersPG18Parameters TEMPORARY 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 …Parameters ParametersManual ChaptersPG18Parameters PREPARE This key word is ignored. name The name of the prepared statement to deallocate. ALL Deallocate all prepared statements.Parameters ParametersManual ChaptersPG18Parameters name 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 i…Parameters ParametersManual ChaptersPG18Parameters with_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 …Parameters ParametersManual ChaptersPG18Parameters PLANS 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, …Parameters ParametersManual ChaptersPG18Parameters code 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 …Parameters ParametersManual ChaptersPG18Parameters IF 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 object…Parameters ParametersManual ChaptersPG18Parameters name 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 al…Parameters ParametersManual ChaptersPG18Parameters IF 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. ar…Parameters ParametersManual ChaptersPG18Parameters IF 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 …Parameters ParametersManual ChaptersPG18Parameters IF 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. CASCA…Parameters ParametersManual ChaptersPG18Parameters IF 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. CA…Parameters ParametersManual ChaptersPG18Parameters IF 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 c…Parameters ParametersManual ChaptersPG18Parameters IF 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 Automatic…Parameters ParametersManual ChaptersPG18Parameters IF 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 obje…Parameters ParametersManual ChaptersPG18Parameters IF 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 …Parameters ParametersManual ChaptersPG18Parameters IF 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 Automatical…Parameters ParametersManual ChaptersPG18Parameters IF 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. CAS…Parameters ParametersManual ChaptersPG18Parameters IF 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 argumen…Parameters ParametersManual ChaptersPG18Parameters CONCURRENTLY Drop the index without locking out concurrent selects, inserts, updates, and deletes on the index's table. A normal DROP INDEX acquires an ACCESS EXCLUSIVE lock on th…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the language does not exist. A notice is issued in this case. name The name of an existing procedural language. CASCADE Automatically drop objec…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the materialized view does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the materialized view to r…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the operator class does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing operator class. i…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the operator does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing operator. left_type The…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the operator family does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing operator family.…Parameters