change the definition of an aggregate function NAME ALTER_AGGREGATE - change the definition of an aggregate function SYNOPSIS ALTER AGGREGATE name ( aggregat......ive syntaxes for referencing ordered-set aggregates are described under ALTER AGGREGATE ( ALTER_AGGREGATE (7)). EXAMPLES To remove the aggregate function myavg for type integer:…define a new aggregate function NAME CREATE_AGGREGATE - define a new aggregate function SYNOPSIS CREATE [ OR REPLACE ] AGGREGATE name ( [ argmode ] [ argname ] arg_data_type [ , ..…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 …...be an aggregate function, a normal function, or a procedure. See under ALTER AGGREGATE ( ALTER_AGGREGATE (7)), ALTER FUNCTION ( ALTER_FUNCTION (7)), and ALTER PROCEDURE ( ALTER_…remove a routine NAME DROP_ROUTINE - remove a routine SYNOPSIS DROP ROUTINE [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ] DE…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 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 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 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…define extended statistics NAME CREATE_STATISTICS - define extended statistics SYNOPSIS CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ] ON ( expression ) FROM table_name CR…define a new index NAME CREATE_INDEX - define a new index SYNOPSIS CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] name ] ON [ ONLY ] table_name [ USING method ] ( { c…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…change the definition of a materialized view NAME ALTER_MATERIALIZED_VIEW - change the definition of a materialized view SYNOPSIS ALTER MATERIALIZED VIEW [ IF EXISTS ] name action …change a database role NAME ALTER_USER - change a database role SYNOPSIS ALTER USER role_specification [ WITH ] option [ ... ] where option can be: SUPERUSER | NOSUPERUSER | CREATE…change the definition of a view NAME ALTER_VIEW - change the definition of a view SYNOPSIS ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name SET DEFAULT expression ALTER V…change the definition of a text search configuration NAME ALTER_TEXT_SEARCH_CONFIGURATION - change the definition of a text search configuration SYNOPSIS ALTER TEXT SEARCH CONFIGUR…change the definition of a domain NAME ALTER_DOMAIN - change the definition of a domain SYNOPSIS ALTER DOMAIN name { SET DEFAULT expression | DROP DEFAULT } ALTER DOMAIN name { SET…