Search PostgreSQL documentation

ParametersManual ChaptersPG18DESCRIBEprepared_name # The name of a prepared statement. This can be an SQL identifier or a host variable. descriptor_name # A descriptor name. It is case sensitive. It can be an SQL identifier or … ParametersManual ChaptersPG18DISCONNECTconnection_name # A database connection name established by the CONNECT command. CURRENT # Close the “current” connection, which is either the most recently opened connection, or the connect… ParametersManual ChaptersPG18EXECUTE IMMEDIATEstring # A literal string or a host variable containing the SQL statement to be executed. ParametersManual ChaptersPG18GET DESCRIPTORdescriptor_name # A descriptor name. descriptor_header_item # A token identifying which header information item to retrieve. Only COUNT, to get the number of columns in the result set, is cu… ParametersManual ChaptersPG18OPENcursor_name # The name of the cursor to be opened. This can be an SQL identifier or a host variable. value # A value to be bound to a placeholder in the cursor. This can be an SQL constant, … ParametersManual ChaptersPG18PREPAREprepared_name # An identifier for the prepared query. string # A literal string or a host variable containing a preparable SQL statement, one of SELECT, INSERT, UPDATE, or DELETE. Use questi… ParametersManual ChaptersPG18SET CONNECTIONconnection_name # A database connection name established by the CONNECT command. CURRENT # Set the connection to the current connection (thus, nothing happens). ParametersManual ChaptersPG18SET DESCRIPTORdescriptor_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 currently suppor… ParametersManual ChaptersPG18TYPEtype_name # The name for the new type. It must be a valid C type name. ctype # A C type specification. ParametersManual ChaptersPG18VARvarname # A C variable name. ctype # A C type specification. ParametersManual ChaptersPG18WHENEVERSee Section 34.8.1 for a description of the parameters. parametersManual ChaptersPG18The 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 access to (by way… ParametersManual ChaptersPG18ABORTWORKTRANSACTION 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 ChaptersPG18ALTER AGGREGATEname 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 an argument… ParametersManual ChaptersPG18ALTER COLLATIONname 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 for the coll… ParametersManual ChaptersPG18ALTER CONVERSIONname 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 schema for the c… ParametersManual ChaptersPG18ALTER DATABASEname 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 made to this d… ParametersManual ChaptersPG18ALTER DEFAULT PRIVILEGEStarget_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 default privil… ParametersManual ChaptersPG18ALTER DOMAINname 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 drop or re… ParametersManual ChaptersPG18ALTER EVENT TRIGGERname 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 | ALWAYS ] … ParametersManual ChaptersPG18ALTER EXTENSIONname 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, ALTER EXTENS… ParametersManual ChaptersPG18ALTER FOREIGN DATA WRAPPERname 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 the foreign… ParametersManual ChaptersPG18ALTER FOREIGN TABLEname 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, the table a… ParametersManual ChaptersPG18ALTER FUNCTIONname 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, OUT, INOUT,… ParametersManual ChaptersPG18ALTER GROUPgroup_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 create or dro… ParametersManual ChaptersPG18ALTER INDEXIF 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 the index col… ParametersManual ChaptersPG18ALTER LANGUAGEname Name of a language new_name The new name of the language new_owner The new owner of the language ParametersManual ChaptersPG18ALTER LARGE OBJECTlarge_object_oid OID of the large object to be altered new_owner The new owner of the large object ParametersManual ChaptersPG18ALTER MATERIALIZED VIEWname 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 materialized view is t… ParametersManual ChaptersPG18ALTER OPERATOR CLASSname 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 operator class. … ParametersManual ChaptersPG18ALTER OPERATORname 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_type The da… ParametersManual ChaptersPG18ALTER OPERATOR FAMILYname 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's strategy… ParametersManual ChaptersPG18ALTER POLICYname 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 The role(s… ParametersManual ChaptersPG18ALTER PROCEDUREname 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, OUT, INOUT… ParametersManual ChaptersPG18ALTER PUBLICATIONname 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 affected. If … ParametersManual ChaptersPG18ALTER ROLEname # 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 the current s… ParametersManual ChaptersPG18ALTER RULEname 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. ParametersManual ChaptersPG18ALTER SCHEMAname 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 owner of the sc… ParametersManual ChaptersPG18ALTER SEQUENCEname 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 The option… ParametersManual ChaptersPG18ALTER SERVERname 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 specify the …