remove an aggregate function NAME DROP_AGGREGATE - remove an aggregate function SYNOPSIS DROP AGGREGATE [ IF EXISTS ] name ( aggregate_sig...define a new aggregate function NAME CREATE_AGGREGATE - define a new aggregate function SYNOPSIS CREATE [ OR REPLACE ] AGGREGATE name ( [ argmode ] [ argname ] arg_data_type [ , ..…...in the SQL standard. SEE ALSO CREATE AGGREGATE ( CREATE_AGGREGATE (7)), DROP AGGREGATE ( DROP_AGGREGATE (7))change the definition of an extension NAME ALTER_EXTENSION - change the definition of an extension SYNOPSIS ALTER EXTENSION name UPDATE [ TO new_version ] ALTER EXTENSION name SET …...ncludes aggregate functions, normal functions, and procedures. See under DROP AGGREGATE ( DROP_AGGREGATE (7)), DROP FUNCTION ( DROP_FUNCTION (7)), and DROP PROCEDURE ( DROP_PROC…change the definition of a routine NAME ALTER_ROUTINE - change the definition of a routine SYNOPSIS ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ …define or change a security label applied to an object NAME SECURITY_LABEL - define or change a security label applied to an object SYNOPSIS SECURITY LABEL [ FOR provider ] ON { TA…define or change the comment of an object NAME COMMENT - define or change the comment of an object SYNOPSIS COMMENT ON { ACCESS METHOD object_name | AGGREGATE aggregate_name ( aggr…define a new rewrite rule NAME CREATE_RULE - define a new rewrite rule SYNOPSIS CREATE [ OR REPLACE ] RULE name AS ON event TO table_name [ WHERE condition ] DO [ ALSO | INSTEAD ] …define extended statistics NAME CREATE_STATISTICS - define extended statistics SYNOPSIS CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ] ON ( expression ) FROM table_name CR…define access privileges NAME GRANT - define access privileges SYNOPSIS GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER | MAINTAIN } [, ...] | ALL [ P…define default access privileges NAME ALTER_DEFAULT_PRIVILEGES - define default access privileges SYNOPSIS ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN…define a new row-level security policy for a table NAME CREATE_POLICY - define a new row-level security policy for a table SYNOPSIS CREATE POLICY name ON table_name [ AS { PERMISSI…retrieve rows from a table or view NAME SELECT, TABLE, WITH - retrieve rows from a table or view SYNOPSIS [ WITH [ RECURSIVE ] with_query [, ...] ] SELECT [ ALL | DISTINCT [ ON ( e…define a new view NAME CREATE_VIEW - define a new view SYNOPSIS CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW name [ ( column_name [, ...] ) ] [ WITH ( view_option_…remove an operator class NAME DROP_OPERATOR_CLASS - remove an operator class SYNOPSIS DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DESCRIPTION D…remove an index NAME DROP_INDEX - remove an index SYNOPSIS DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DESCRIPTION DROP INDEX drops an existing in…remove a function NAME DROP_FUNCTION - remove a function SYNOPSIS DROP FUNCTION [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT …remove a procedure NAME DROP_PROCEDURE - remove a procedure SYNOPSIS DROP PROCEDURE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTR…remove an operator family NAME DROP_OPERATOR_FAMILY - remove an operator family SYNOPSIS DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ] DESCRIPTI…