Search PostgreSQL documentation

ParametersManual ChaptersPG18Parameters connection_name # A database connection name established by the CONNECT command. CURRENT # Set the connection to the current connection (thus, nothing happens).Parameters ParametersManual ChaptersPG18Parameters descriptor_name # A descriptor name. descriptor_header_item # A token identifying which header information item to set. Only COUNT, to set the number of descriptor items, is curre…Parameters ParametersManual ChaptersPG18Parameters type_name # The name for the new type. It must be a valid C type name. ctype # A C type specification.Parameters ParametersManual ChaptersPG18Parameters varname # A C variable name. ctype # A C type specification.Parameters ParametersManual ChaptersPG18Parameters See Section 34.8.1 for a description of the parameters.Parameters parametersManual ChaptersPG1835.33. parameters The view parameters contains information about the parameters (arguments) of all functions in the current database. Only those functions are shown that the current user has…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 (optionally schema-qualified) of an existing aggregate function. argmode The mode of an argument: IN or VARIADIC. If omitted, the default is IN. argname The name of …Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing collation. new_name The new name of the collation. new_owner The new owner of the collation. new_schema The new schema f…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing conversion. new_name The new name of the conversion. new_owner The new owner of the conversion. new_schema The new schem…Parameters ParametersManual ChaptersPG18Parameters name The name of the database whose attributes are to be altered. allowconn If false then no one can connect to this database. connlimit How many concurrent connections can be mad…Parameters ParametersManual ChaptersPG18Parameters target_role Change default privileges for objects created by the target_role, or the current role if unspecified. schema_name The name of an existing schema. If specified, the def…Parameters ParametersManual ChaptersPG18Parameters name The name (possibly schema-qualified) of an existing domain to alter. domain_constraint New domain constraint for the domain. constraint_name Name of an existing constraint to…Parameters ParametersManual ChaptersPG18Parameters name The name of an existing trigger to alter. new_owner The user name of the new owner of the event trigger. new_name The new name of the event trigger. DISABLE/ENABLE [ REPLICA …Parameters ParametersManual ChaptersPG18Parameters name The name of an installed extension. new_version The desired new version of the extension. This can be written as either an identifier or a string literal. If not specified, A…Parameters ParametersManual ChaptersPG18Parameters name The name of an existing foreign-data wrapper. HANDLER handler_function Specifies a new handler function for the foreign-data wrapper. NO HANDLER This is used to specify that …Parameters ParametersManual ChaptersPG18Parameters name The name (possibly schema-qualified) of an existing foreign table to alter. If ONLY is specified before the table name, only that table is altered. If ONLY is not specified, …Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of an existing function. If no argument list is specified, the name must be unique in its schema. argmode The mode of an argument: IN, …Parameters ParametersManual ChaptersPG18Parameters group_name The name of the group (role) to modify. user_name Users (roles) that are to be added to or removed from the group. The users must already exist; ALTER GROUP does not cr…Parameters 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