Section 7: overview, conventions, and miscellany
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…