Listing UDF and triggers?
| От | Jonathan Kop |
|---|---|
| Тема | Listing UDF and triggers? |
| Дата | |
| Msg-id | 380AF27F.13B0C3D2@usko.com обсуждение исходный текст |
| Список | pgsql-general |
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)
В списке pgsql-general по дате отправления: