ALTER OPERATOR – change the definition of an operator Synopsis ALTER OPERATOR name ( { lefttype | NONE } , { righttype | NONE } ) OWNER TO newowner Description ALTER OPERATOR changes the definition of an operator. The only currently available functionality is to change the owner of the operator. You must own the…
ALTER_LARGE_OBJECT – change the definition of a large object Synopsis ALTER LARGE OBJECT large_object_oid OWNER TO new_owner Description ALTER LARGE OBJECT changes the definition of a large object. The only functionality is to assign a new owner. You must be superuser or owner of the large object to use ALTER LARGE OBJECT. Parameters large_object_oid OID…
ALTER LANGUAGE – change the definition of a procedural language Synopsis ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO newname ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO new_owner Description ALTER LANGUAGE changes the definition of a procedural language. The only functionality is to rename the language or assign a new owner. You must be…
ALTER INDEX – change the definition of an index Synopsis ALTER INDEX name RENAME TO new_name ALTER INDEX name SET TABLESPACE tablespace_name ALTER INDEX name SET ( storage_parameter = value [, … ] ) ALTER INDEX name RESET ( storage_parameter [, … ] ) Description ALTER INDEX changes the definition of an existing index. There…
ALTER GROUP – change role name or membership Synopsis ALTER GROUP groupname ADD USER username [, … ] ALTER GROUP groupname DROP USER username [, … ] ALTER GROUP groupname RENAME TO newname Description ALTER GROUP changes the attributes of a user group. This is an obsolete command, though still accepted for backwards compatibility, because…
ALTER FUNCTION – change the definition of a function Synopsis ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, …] ] ) action [ … ] [ RESTRICT ] ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, …] ] ) RENAME TO new_name ALTER FUNCTION name…
ALTER_FOREIGN_TABLE – change the definition of a foreign table Synopsis ALTER FOREIGN TABLE [ IF EXISTS ] name action [, … ] ALTER FOREIGN TABLE [ IF EXISTS ] name RENAME [ COLUMN ] column_name TO new_column_name ALTER FOREIGN TABLE [ IF EXISTS ] name RENAME TO new_name ALTER FOREIGN TABLE [ IF EXISTS ]…
ALTER FOREIGN DATA WRAPPER – change the definition of a foreign-data wrapper Synopsis ALTER FOREIGN DATA WRAPPER name [ VALIDATOR valfunction | NO VALIDATOR ] [ OPTIONS ( [ ADD | SET | DROP ] option [‘value’] [, … ]) ] ALTER FOREIGN DATA WRAPPER name OWNER TO new_owner Description ALTER FOREIGN DATA WRAPPER changes…
ALTER_EXTENSION – change the definition of an extension Synopsis ALTER EXTENSION name UPDATE [ TO new_version ] ALTER EXTENSION name SET SCHEMA new_schema ALTER EXTENSION name ADD member_object ALTER EXTENSION name DROP member_object where member_object is: AGGREGATE agg_name (agg_type [, …] ) | CAST (source_type AS target_type) | COLLATION object_name | CONVERSION object_name | DOMAIN…
ALTER DOMAIN – change the definition of a domain Synopsis ALTER DOMAIN name { SET DEFAULT expression | DROP DEFAULT } ALTER DOMAIN name { SET | DROP } NOT NULL ALTER DOMAIN name ADD domain_constraint ALTER DOMAIN name DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ] ALTER DOMAIN name OWNER TO new_owner ALTER DOMAIN…
ALTER_DEFAULT_PRIVILEGES – define default access privileges Synopsis ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, …] ] [ IN SCHEMA schema_name [, …] ] abbreviated_grant_or_revoke where abbreviated_grant_or_revoke is one of: GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } [, …] | ALL…
ALTER DATABASE – change a database Synopsis ALTER DATABASE name [ [ WITH ] option [ … ] ] where option can be: CONNECTION LIMIT connlimit ALTER DATABASE name RENAME TO newname ALTER DATABASE name OWNER TO new_owner ALTER DATABASE name SET TABLESPACE new_tablespace ALTER DATABASE name SET configuration_parameter { TO | = } {…
ALTER CONVERSION – change the definition of a conversion Synopsis ALTER CONVERSION name RENAME TO newname ALTER CONVERSION name OWNER TO newowner Description ALTER CONVERSION changes the definition of a conversion. You must own the conversion to use ALTER CONVERSION. To alter the owner, you must also be a direct or indirect member of the…
ALTER_COLLATION – change the definition of a collation Synopsis ALTER COLLATION name RENAME TO new_name ALTER COLLATION name OWNER TO new_owner ALTER COLLATION name SET SCHEMA new_schema Description ALTER COLLATION changes the definition of a collation. You must own the collation to use ALTER COLLATION. To alter the owner, you must also be a direct…
ALTER AGGREGATE – change the definition of an aggregate function Synopsis ALTER AGGREGATE name ( type [ , … ] ) RENAME TO new_name ALTER AGGREGATE name ( type [ , … ] ) OWNER TO new_owner ALTER AGGREGATE name ( type [ , … ] ) SET SCHEMA new_schema Description ALTER AGGREGATE changes the…
ABORT – abort the current transaction Synopsis ABORT [ WORK | TRANSACTION ] Description ABORT rolls back the current transaction and causes all the updates made by the transaction to be discarded. This command is identical in behavior to the standard SQL command ROLLBACK [rollback(7)], and is present only for historical reasons. Parameters WORK TRANSACTION…
zos-remote.conf – the audisp-racf plugin configuration file Description zos-remote.conf controls the configuration for the audispd-zos-remote(8) Audit dispatcher plugin. The default location for this file is /etc/audisp/zos-remote.conf, however, a different file can be specified as the first argument to the audispd-zos-remote plugin. See audispd-zos-remote(8) and auditd(8). The options available are as follows: server This is the…
zos-remote.conf – the audisp-racf plugin configuration file Description zos-remote.conf controls the configuration for the audispd-zos-remote(8) Audit dispatcher plugin. The default location for this file is /etc/audisp/zos-remote.conf, however, a different file can be specified as the first argument to the audispd-zos-remote plugin. See audispd-zos-remote(8) and auditd(8). The options available are as follows: server This is the…
zathurarc – zathura configuration file Synopsis /etc/zathurarc, $XDG_CONFIG_HOME/zathura/zathurarc Description The zathurarc file is a simple plain text file that can be populated with various commands to change the behaviour and the look of zathura which we are going to describe in the following subsections. Each line (besides empty lines and comments (which start with a…
zarafa-unix.cfg – The Zarafa Unix user plugin configuration file Synopsis unix.cfg Description The unix.cfg is a configuration file for the unix user plugin. All options to correctly retrieve user and group information can be set here. File Format The file consists of one big section, but parameters can be grouped by functionality. The parameters are…