Functions, aggregates, and user types
Querying system_schema
tables directly to get information about
user-defined functions, aggregates, and user types.
Currently, the system_schema
tables are the only method of
displaying information about user-defined functions, aggregates, and user types.
Procedure
-
Show all user-defined functions in the
system_schema.functions
table.SELECT * FROM system_schema.functions;
-
Show all user-defined aggregates in the
system_schema.aggregates
table.SELECT * FROM system_schema.aggregates;
-
Show all user-defined types in the
system_schema.types
table.SELECT * FROM system_schema.types;