Search PostgreSQL documentation

ParametersManual ChaptersPG18Parameters IF EXISTS Do not throw an error if the index does not exist. A notice is issued in this case. column_number The ordinal number refers to the ordinal (left-to-right) position of th…Parameters ParametersManual ChaptersPG18Parameters name Name of a language new_name The new name of the language new_owner The new owner of the languageParameters ParametersManual ChaptersPG18Parameters large_object_oid OID of the large object to be altered new_owner The new owner of the large objectParameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing materialized view. column_name Name of an existing column. extension_name The name of the extension that the materialize…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing operator class. index_method The name of the index method this operator class is for. new_name The new name of the opera…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing operator. left_type The data type of the operator's left operand; write NONE if the operator has no left operand. right_…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing operator family. index_method The name of the index method this operator family is for. strategy_number The index method…Parameters ParametersManual ChaptersPG18Parameters name The name of an existing policy to alter. table_name The name (optionally schema-qualified) of the table that the policy is on. new_name The new name for the policy. role_name…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing procedure. If no argument list is specified, the name must be unique in its schema. argmode The mode of an argument: IN,…Parameters ParametersManual ChaptersPG18Parameters name The name of an existing publication whose definition is to be altered. table_name Name of an existing table. If ONLY is specified before the table name, only that table is af…Parameters ParametersManual ChaptersPG18Parameters name # The name of the role whose attributes are to be altered. CURRENT_ROLECURRENT_USER # Alter the current user instead of an explicitly identified role. SESSION_USER # Alter th…Parameters ParametersManual ChaptersPG18Parameters name The name of an existing rule to alter. table_name The name (optionally schema-qualified) of the table or view that the rule applies to. new_name The new name for the rule.Parameters ParametersManual ChaptersPG18Parameters name The name of an existing schema. new_name The new name of the schema. The new name cannot begin with pg_, as such names are reserved for system schemas. new_owner The new owne…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of a sequence to be altered. IF EXISTS Do not throw an error if the sequence does not exist. A notice is issued in this case. data_type…Parameters ParametersManual ChaptersPG18Parameters name The name of an existing server. new_version New server version. OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) Change options for the server. ADD, SET, and DROP s…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of the statistics object to be altered. new_owner The user name of the new owner of the statistics object. new_name The new name for th…Parameters ParametersManual ChaptersPG18Parameters name The name of a subscription whose properties are to be altered. CONNECTION 'conninfo' This clause replaces the connection string originally set by CREATE SUBSCRIPTION. See the…Parameters ParametersManual ChaptersPG18Parameters configuration_parameter Name of a settable configuration parameter. Available parameters are documented in Chapter 19. value New value of the parameter. Values can be specified as…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 an existing table to alter. If ONL…Parameters ParametersManual ChaptersPG18Parameters name The name of an existing tablespace. new_name The new name of the tablespace. The new name cannot begin with pg_, as such names are reserved for system tablespaces. new_owner …Parameters ParametersManual ChaptersPG18Parameters name The name of an existing trigger to alter. table_name The name of the table on which this trigger acts. new_name The new name for the trigger. extension_name The name of the e…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing text search configuration. token_type The name of a token type that is emitted by the configuration's parser. dictionary…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing text search dictionary. option The name of a template-specific option to be set for this dictionary. value The new value…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing text search parser. new_name The new name of the text search parser. new_schema The new schema for the text search parse…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing text search template. new_name The new name of the text search template. new_schema The new schema for the text search t…Parameters ParametersManual ChaptersPG18Parameters name The name (possibly schema-qualified) of an existing type to alter. new_name The new name for the type. new_owner The user name of the new owner of the type. new_schema The ne…Parameters ParametersManual ChaptersPG18Parameters user_name User name of the mapping. CURRENT_ROLE, CURRENT_USER, and USER match the name of the current user. PUBLIC is used to match all present and future user names in the syste…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing view. column_name Name of an existing column. new_column_name New name for an existing column. IF EXISTS Do not throw an…Parameters ParametersManual ChaptersPG18Parameters VERBOSE Enables display of progress messages at INFO level. SKIP_LOCKED Specifies that ANALYZE should not wait for any conflicting locks to be released when beginning work on a re…Parameters ParametersManual ChaptersPG18Parameters WORKTRANSACTION Optional key words. They have no effect. Refer to SET TRANSACTION for information on the meaning of the other parameters to this statement.Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of the procedure. argument An argument expression for the procedure call. Arguments can include parameter names, using the syntax name …Parameters ParametersManual ChaptersPG18Parameters name The name of an open cursor to close. ALL Close all open cursors.Parameters ParametersManual ChaptersPG18Parameters table_name The name (possibly schema-qualified) of a table. index_name The name of an index. VERBOSE Prints a progress report as each table is clustered at INFO level. boolean Spe…Parameters ParametersManual ChaptersPG18Parameters object_namerelation_name.column_nameaggregate_nameconstraint_namefunction_nameoperator_namepolicy_nameprocedure_nameroutine_namerule_nametrigger_name The name of the object to be …Parameters ParametersManual ChaptersPG18Parameters transaction_id The transaction identifier of the transaction that is to be committed.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 characteristic…Parameters ParametersManual ChaptersPG18Parameters table_name The name (optionally schema-qualified) of an existing table. column_name An optional list of columns to be copied. If no column list is specified, all columns of the ta…Parameters ParametersManual ChaptersPG18Parameters name The name of the access method to be created. access_method_type This clause specifies the type of access method to define. Only TABLE and INDEX are supported at present. hand…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of the aggregate function to create. argmode The mode of an argument: IN or VARIADIC. (Aggregate functions do not support OUT arguments…Parameters ParametersManual ChaptersPG18Parameters source_type The name of the source data type of the cast. target_type The name of the target data type of the cast. function_name[(argument_type [, ...])] The function used to per…Parameters