Search PostgreSQL documentation

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 ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if a collation with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing collation …Parameters ParametersManual ChaptersPG18Parameters DEFAULT The DEFAULT clause indicates that this conversion is the default for this particular source to destination encoding. There should be only one default encoding in a schema …Parameters ParametersManual ChaptersPG18Parameters name The name of a database to create. user_name The role name of the user who will own the new database, or DEFAULT to use the default (namely, the user executing the command). T…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of a domain to be created. data_type The underlying data type of the domain. This can include array specifiers. collation An optional c…Parameters ParametersManual ChaptersPG18Parameters name The name to give the new trigger. This name must be unique within the database. event The name of the event that triggers a call to the given function. See Section 38.1 for m…Parameters ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if an extension with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing extension…Parameters ParametersManual ChaptersPG18Parameters name The name of the foreign-data wrapper to be created. HANDLER handler_function handler_function is the name of a previously registered function that will be called to retrieve …Parameters ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if a relation with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing relation is…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of the function to create. argmode The mode of an argument: IN, OUT, INOUT, or VARIADIC. If omitted, the default is IN. Only OUT argume…Parameters ParametersManual ChaptersPG18Parameters UNIQUE Causes the system to check for duplicate values in the table when the index is created (if data already exist) and each time data is added. Attempts to insert or update dat…Parameters ParametersManual ChaptersPG18Parameters TRUSTED TRUSTED specifies that the language does not grant access to data that the user would not otherwise have. If this key word is omitted when registering the language, only u…Parameters ParametersManual ChaptersPG18Parameters IF NOT EXISTS Do not throw an error if a materialized view with the same name already exists. A notice is issued in this case. Note that there is no guarantee that the existing ma…Parameters ParametersManual ChaptersPG18Parameters name The name of the operator class to be created. The name can be schema-qualified. DEFAULT If present, the operator class will become the default operator class for its data typ…Parameters ParametersManual ChaptersPG18Parameters name The name of the operator to be defined. See above for allowable characters. The name can be schema-qualified, for example CREATE OPERATOR myschema.+ (...). If not, then the o…Parameters ParametersManual ChaptersPG18Parameters name The name of the operator family to be created. The name can be schema-qualified. index_method The name of the index method this operator family is for.Parameters ParametersManual ChaptersPG18Parameters name The name of the policy to be created. This must be distinct from the name of any other policy for the table. table_name The name (optionally schema-qualified) of the table th…Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of the procedure to create. argmode The mode of an argument: IN, OUT, INOUT, or VARIADIC. If omitted, the default is IN. argname The na…Parameters ParametersManual ChaptersPG18Parameters name The name of the new publication. FOR TABLE Specifies a list of tables to add to the publication. If ONLY is specified before the table name, only that table is added to the p…Parameters ParametersManual ChaptersPG18Parameters name The name of the new role. SUPERUSERNOSUPERUSER These clauses determine whether the new role is a “superuser”, who can override all access restrictions within the database. Su…Parameters ParametersManual ChaptersPG18Parameters name The name of a rule to create. This must be distinct from the name of any other rule for the same table. Multiple rules on the same table and same event type are applied in al…Parameters ParametersManual ChaptersPG18Parameters schema_name The name of a schema to be created. If this is omitted, the user_name is used as the schema name. The name cannot begin with pg_, as such names are reserved for system…Parameters