ALTER AGGREGATE SQL - Language Statements ALTER AGGREGATE change the definition of an aggregate function ALTER AGGREGATE ALTER AGGREGATE name ( type ) RENAME TO new_name ALTER AGGREGATE name ( type ) OWNER TO new_owner ALTER AGGREGATE name ( type ) SET SCHEMA new_schema ALTER AGGREGATE changes the definition of an aggregate function. You must own the aggregate function to use ALTER AGGREGATE; except for ALTER AGGREGATE OWNER, which may only be executed by a superuser. To change the schema of an aggregate function, you must also have CREATE privilege on the new schema. name The name (optionally schema-qualified) of an existing aggregate function. type The argument data type of the aggregate function, or * if the function accepts any data type. new_name The new name of the aggregate function. new_owner The new owner of the aggregate function. new_schema The new schema for the aggregate function. To rename the aggregate function myavg for type integer to my_average: ALTER AGGREGATE myavg(integer) RENAME TO my_average; To change the owner of the aggregate function myavg for type integer to joe: ALTER AGGREGATE myavg(integer) OWNER TO joe; To move the aggregate function myavg for type integer into schema myschema: ALTER AGGREGATE myavg(integer) SET SCHEMA myschema; There is no ALTER AGGREGATE statement in the SQL standard.