Re: INFORMATION_SCHEMA.routine_column_usage

On 29.11.23 15:01, Peter Eisentraut wrote: Here https://www.postgresql.org/docs/current/infoschema-routine-column-usage.html it is stated that "The view |routine_column_usage| is meant to identify all columns that

Re: INFORMATION_SCHEMA.routine_column_usage

Here https://www.postgresql.org/docs/current/infoschema-routine-column-usage.html it is stated that "The view |routine_column_usage| is meant to identify all columns that are used by a function or procedure. This

INFORMATION_SCHEMA.routine_column_usage

RIMARY KEY (person_id)); CREATE FUNCTION f_reg_person(p_given_name Person.given_name%TYPE) RETURNS Person.person_id%TYPE LANGUAGE SQL SECURITY DEFINER BEGIN ATOMIC INSERT INTO Person (given_name) VALUES (p_given_name) RETURNING person_id; END; SELECT * FROM Information_schema.routine_column_usage; Returns i