Search PostgreSQL documentation

ParametersManual ChaptersPG18ALTER STATISTICSname 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 the statistic… ParametersManual ChaptersPG18ALTER SUBSCRIPTIONname 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 there for more… ParametersManual ChaptersPG18ALTER SYSTEMconfiguration_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 string con… ParametersManual ChaptersPG18ALTER 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 an existing table to alter. If ONLY is specif… ParametersManual ChaptersPG18ALTER TABLESPACEname 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 The new own… ParametersManual ChaptersPG18ALTER TRIGGERname 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 extension th… ParametersManual ChaptersPG18ALTER TEXT SEARCH CONFIGURATIONname 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_name The n… ParametersManual ChaptersPG18ALTER TEXT SEARCH DICTIONARYname 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 to use for… ParametersManual ChaptersPG18ALTER TEXT SEARCH PARSERname 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 parser. ParametersManual ChaptersPG18ALTER TEXT SEARCH TEMPLATEname 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 template. ParametersManual ChaptersPG18ALTER TYPEname 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 new schema fo… ParametersManual ChaptersPG18ALTER USER MAPPINGuser_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 system. server_n… ParametersManual ChaptersPG18ALTER VIEWname 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 error if t… ParametersManual ChaptersPG18ANALYZEVERBOSE 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 relation: if … ParametersManual ChaptersPG18BEGINWORKTRANSACTION Optional key words. They have no effect. Refer to SET TRANSACTION for information on the meaning of the other parameters to this statement. ParametersManual ChaptersPG18CALLname 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 => value. T… ParametersManual ChaptersPG18CLOSEname The name of an open cursor to close. ALL Close all open cursors. ParametersManual ChaptersPG18CLUSTERtable_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 Specifies whet… ParametersManual ChaptersPG18COMMENTobject_namerelation_name.column_nameaggregate_nameconstraint_namefunction_nameoperator_namepolicy_nameprocedure_nameroutine_namerule_nametrigger_name The name of the object to be commented. … ParametersManual ChaptersPG18COMMIT PREPAREDtransaction_id The transaction identifier of the transaction that is to be committed. ParametersManual ChaptersPG18COMMITWORKTRANSACTION # 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 … ParametersManual ChaptersPG18COPYtable_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 table except … ParametersManual ChaptersPG18CREATE ACCESS METHODname 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. handler_functio… ParametersManual ChaptersPG18CREATE AGGREGATEname 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.) If omitt… ParametersManual ChaptersPG18CREATE CASTsource_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 perform the ca… ParametersManual ChaptersPG18CREATE COLLATIONIF 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 is anything… ParametersManual ChaptersPG18CREATE CONVERSIONDEFAULT 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 for the enc… ParametersManual ChaptersPG18CREATE DATABASEname 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). To create a … ParametersManual ChaptersPG18CREATE DOMAINname 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 collation fo… ParametersManual ChaptersPG18CREATE EVENT TRIGGERname 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 more informa… ParametersManual ChaptersPG18CREATE EXTENSIONIF 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 is anythin… ParametersManual ChaptersPG18CREATE FOREIGN DATA WRAPPERname 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 the executi… ParametersManual ChaptersPG18CREATE FOREIGN TABLEIF 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 anything l… ParametersManual ChaptersPG18CREATE FUNCTIONname 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 arguments can fol… ParametersManual ChaptersPG18CREATE INDEXUNIQUE 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 data which wou… ParametersManual ChaptersPG18CREATE LANGUAGETRUSTED 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 users with t… ParametersManual ChaptersPG18CREATE MATERIALIZED VIEWIF 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 materialized … ParametersManual ChaptersPG18CREATE OPERATOR CLASSname 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 type. At most … ParametersManual ChaptersPG18CREATE OPERATORname 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 operator is … ParametersManual ChaptersPG18CREATE OPERATOR FAMILYname 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.