Search PostgreSQL documentation

ParametersManual ChaptersPG18DROP INDEXCONCURRENTLY 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 the table, bl… ParametersManual ChaptersPG18DROP LANGUAGEIF 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 objects that dep… ParametersManual ChaptersPG18DROP MATERIALIZED VIEWIF 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 remove. CASC… ParametersManual ChaptersPG18DROP OPERATOR CLASSIF 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. index_method… ParametersManual ChaptersPG18DROP OPERATORIF 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 data type … ParametersManual ChaptersPG18DROP OPERATOR FAMILYIF 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. index_meth… ParametersManual ChaptersPG18DROP POLICYIF 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-qualified) of the t… ParametersManual ChaptersPG18DROP PROCEDUREIF 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 mode of an… ParametersManual ChaptersPG18DROP PUBLICATIONIF 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 not have any … ParametersManual ChaptersPG18DROP ROLEIF 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. ParametersManual ChaptersPG18DROP RULEIF 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) of the table… ParametersManual ChaptersPG18DROP SCHEMAIF 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, etc.) that ar… ParametersManual ChaptersPG18DROP SEQUENCEIF 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 drop objects… ParametersManual ChaptersPG18DROP SERVERIF 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 on the serv… ParametersManual ChaptersPG18DROP STATISTICSIF 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 drop. CASCAD… ParametersManual ChaptersPG18DROP SUBSCRIPTIONIF 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 do not hav… ParametersManual ChaptersPG18DROP TABLEIF 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 Automatically drop obj… ParametersManual ChaptersPG18DROP TABLESPACEIF 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. ParametersManual ChaptersPG18DROP TRANSFORMIF 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 language of … ParametersManual ChaptersPG18DROP TRIGGERIF 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-qualified) of t… ParametersManual ChaptersPG18DROP TEXT SEARCH CONFIGURATIONIF 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 search confi… ParametersManual ChaptersPG18DROP TEXT SEARCH DICTIONARYIF 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 search dictiona… ParametersManual ChaptersPG18DROP TEXT SEARCH PARSERIF 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 parser. CASC… ParametersManual ChaptersPG18DROP TEXT SEARCH TEMPLATEIF 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 template. … ParametersManual ChaptersPG18DROP TYPEIF 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 Automatically dro… ParametersManual ChaptersPG18DROP USER MAPPINGIF 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 the name o… ParametersManual ChaptersPG18DROP VIEWIF 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 Automatically drop obj… ParametersManual ChaptersPG18ENDWORKTRANSACTION 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 (see SET TRAN… ParametersManual ChaptersPG18EXECUTEname 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 compatible with t… ParametersManual ChaptersPG18EXPLAINANALYZE Carry out the command and show actual run times and other statistics. This parameter defaults to FALSE. VERBOSE Display additional information regarding the plan. Specifically, inclu… ParametersManual ChaptersPG18FETCHdirection 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. PRIOR Fetch… ParametersManual ChaptersPG18IMPORT FOREIGN SCHEMAremote_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 foreign tables… ParametersManual ChaptersPG18INSERT ParametersManual ChaptersPG18LISTENchannel Name of a notification channel (any identifier). ParametersManual ChaptersPG18LOCKname 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 table and all i… ParametersManual ChaptersPG18MERGEwith_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 RECURSIVE is… ParametersManual ChaptersPG18NOTIFYchannel 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 simple stri… ParametersManual ChaptersPG18PREPARE TRANSACTIONtransaction_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 must be less t… ParametersManual ChaptersPG18PREPAREname 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 prepared statemen… ParametersManual ChaptersPG18REASSIGN OWNEDold_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 reassigned to new_ro…