SELECT r0.routine_name, r1.routine_name

FROM information_schema.routine_routine_usage rru

JOIN information_schema.routines r0 ON r0.specific_name = rru.specific_name

JOIN information_schema.routines r1 ON r1.specific_name = rru.routine_name;

JOIN information_schema.routines r1 ON r1.specific_name = rru.routine_name

ORDER BY 1, 2;

routine_name | routine_name

----------------+----------------

functest_is_4b | functest_is_4a

(1 row)

SELECT routine_name, sequence_name FROM information_schema.routine_sequence_usage;

SELECT routine_name, sequence_name FROM information_schema.routine_sequence_usage ORDER BY 1, 2;

routine_name | sequence_name

---------------+---------------

functest_is_5 | functest1

functest_is_6 | functest1

(2 rows)

SELECT routine_name, table_name, column_name FROM information_schema.routine_column_usage;

SELECT routine_name, table_name, column_name FROM information_schema.routine_column_usage ORDER BY 1, 2;

routine_name | table_name | column_name

---------------+------------+-------------

functest_is_7 | functest2 | a

(1 row)

SELECT routine_name, table_name FROM information_schema.routine_table_usage;

SELECT routine_name, table_name FROM information_schema.routine_table_usage ORDER BY 1, 2;

routine_name | table_name

---------------+------------

functest_is_7 | functest2

SELECTr0.routine_name,r1.routine_name

FROMinformation_schema.routine_routine_usage rru

JOINinformation_schema.routines r0ONr0.specific_name=rru.specific_name

JOINinformation_schema.routines r1ONr1.specific_name=rru.routine_name;

SELECT routine_name, sequence_nameFROMinformation_schema.routine_sequence_usage;

SELECT routine_name, table_name, column_nameFROMinformation_schema.routine_column_usage;

SELECT routine_name, table_nameFROMinformation_schema.routine_table_usage;

JOINinformation_schema.routines r1ONr1.specific_name=rru.routine_name

ORDER BY1,2;

SELECT routine_name, sequence_nameFROMinformation_schema.routine_sequence_usageORDER BY1,2;

SELECT routine_name, table_name, column_nameFROMinformation_schema.routine_column_usageORDER BY1,2;

SELECT routine_name, table_nameFROMinformation_schema.routine_table_usageORDER BY1,2;

DROPFUNCTION functest_IS_4a CASCADE;

DROPSEQUENCE functest1 CASCADE;