Re: [ADMIN] Which trigger execute which function? - Mailing list pgsql-general

On Wed, 27 Feb 2002, Raymond Chui wrote:

> Previous DBA create a lot of triggers and functions without
> documentation like:
>
> CREATE TRIGGER trigger_name [BEFORE | AFTER] event ON table_name
> FOR EACH ROW EXECUTE PROCEDURE function_name();
>
> Now he is gone. I couldn't find his PL/PGSQL source codes!
>
> I can do
>
> SELECT * FROM pg_proc;
> SELECT * FROM pg_trigger;

select * from pg_trigger,pg_proc where tgfoid=pg_proc.oid;