Search PostgreSQL documentation

ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the policy does not exist. A notice is issued in this case. name The name of the policy to drop. table_name The name (optionally schema-qualifie…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the procedure does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing procedure. argmode The…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the publication does not exist. A notice is issued in this case. name The name of an existing publication. CASCADERESTRICT These key words do no…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the role does not exist. A notice is issued in this case. name The name of the role to remove.Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the rule does not exist. A notice is issued in this case. name The name of the rule to drop. table_name The name (optionally schema-qualified) o…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the schema does not exist. A notice is issued in this case. name The name of a schema. CASCADE Automatically drop objects (tables, functions, et…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the sequence does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of a sequence. CASCADE Automatically d…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the server does not exist. A notice is issued in this case. name The name of an existing server. CASCADE Automatically drop objects that depend …Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the statistics object does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the statistics object to d…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the subscription does not exist. A notice is issued in this case. name The name of a subscription to be dropped. CASCADERESTRICT These key words…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the table does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the table to drop. CASCADE Automatical…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the tablespace does not exist. A notice is issued in this case. name The name of a tablespace.Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the transform does not exist. A notice is issued in this case. type_name The name of the data type of the transform. lang_name The name of the l…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the trigger does not exist. A notice is issued in this case. name The name of the trigger to remove. table_name The name (optionally schema-qual…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the text search configuration does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing text s…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the text search dictionary does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing text sear…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the text search parser does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing text search p…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the text search template does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of an existing text search…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the type does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the data type to remove. CASCADE Automa…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the user mapping does not exist. A notice is issued in this case. user_name User name of the mapping. CURRENT_ROLE, CURRENT_USER, and USER match…Parameters ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the view does not exist. A notice is issued in this case. name The name (optionally schema-qualified) of the view to remove. CASCADE Automatical…Parameters ParametersManual ChaptersPG18Parameters WORKTRANSACTION Optional key words. They have no effect. AND CHAIN If AND CHAIN is specified, a new transaction is immediately started with the same transaction characteristics (s…Parameters ParametersManual ChaptersPG18Parameters name The name of the prepared statement to execute. parameter The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compat…Parameters ParametersManual ChaptersPG18Parameters ANALYZE Carry out the command and show actual run times and other statistics. This parameter defaults to FALSE. VERBOSE Display additional information regarding the plan. Specific…Parameters ParametersManual ChaptersPG18Parameters direction direction defines the fetch direction and number of rows to fetch. It can be one of the following: NEXT Fetch the next row. This is the default if direction is omitted. …Parameters ParametersManual ChaptersPG18Parameters remote_schema The remote schema to import from. The specific meaning of a remote schema depends on the foreign data wrapper in use. LIMIT TO ( table_name [, ...] ) Import only for…Parameters ParametersManual ChaptersPG18ParametersParameters ParametersManual ChaptersPG18Parameters channel Name of a notification channel (any identifier).Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing table to lock. If ONLY is specified before the table name, only that table is locked. If ONLY is not specified, the tabl…Parameters ParametersManual ChaptersPG18Parameters with_query The WITH clause allows you to specify one or more subqueries that can be referenced by name in the MERGE query. See Section 7.8 and SELECT for details. Note that WITH R…Parameters ParametersManual ChaptersPG18Parameters channel Name of the notification channel to be signaled (any identifier). payload The “payload” string to be communicated along with the notification. This must be specified as a …Parameters ParametersManual ChaptersPG18Parameters transaction_id An arbitrary identifier that later identifies this transaction for COMMIT PREPARED or ROLLBACK PREPARED. The identifier must be written as a string literal, and mus…Parameters ParametersManual ChaptersPG18Parameters name An arbitrary name given to this particular prepared statement. It must be unique within a single session and is subsequently used to execute or deallocate a previously prepar…Parameters ParametersManual ChaptersPG18Parameters old_role The name of a role. The ownership of all the objects within the current database, and of all shared objects (databases, tablespaces), owned by this role will be reassigne…Parameters ParametersManual ChaptersPG18Parameters CONCURRENTLY Refresh the materialized view without locking out concurrent selects on the materialized view. Without this option a refresh which affects a lot of rows will tend to …Parameters ParametersManual ChaptersPG18Parameters INDEX Recreate the specified index. This form of REINDEX cannot be executed inside a transaction block when used with a partitioned index. TABLE Recreate all indexes of the specif…Parameters ParametersManual ChaptersPG18Parameters savepoint_name The name of the savepoint to release.Parameters ParametersManual ChaptersPG18Parameters configuration_parameter Name of a settable run-time parameter. Available parameters are documented in Chapter 19 and on the SET reference page. ALL Resets all settable run-time pa…Parameters ParametersManual ChaptersPG18Parameters transaction_id The transaction identifier of the transaction that is to be rolled back.Parameters ParametersManual ChaptersPG18Parameters savepoint_name The savepoint to roll back to.Parameters