Hi,
I was wondering if there is anyway of listing user-defined functions and
triggers associated with a particular database? I've tried '\df', but
it doesn't list a C language dynamically loaded function that I
created. The function itself and the trigger that calls it work
correctly, but I can imagine forgetting the names of the function and
trigger one day when I need to drop them.
If I go into $PGDATA/base/databasename I can do a 'strings pg_trigger'
to see the names of triggers that I have created, however I would like
to be able to see ACTIVE triggers from within the relation itself and on
which actions they will fire. Another oddity with pg_trigger (and
pg_proc in the case of functions) is that it contains the names of both
currently active triggers as well as older triggers that have already
been dropped, anyone know why?
Thanks for your help.
Regards,
Jonathan Kop (jon.kop@usko.com)