Search PostgreSQL documentation

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 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