Wells Oliver <wells(dot)oliver(at)gmail(dot)com> writes:
> Trying to track down every table that is using a certain trigger
> function, what's the best way to do that?
Have a look at the fields tgrelid and tgfoid in your pg_trigger catalog
where you will be enlightened :-)
For starters...
select tgrelid::regclass, tgfoid::regproc from pg_trigger;
Enjoy!
>
> --
> Wells Oliver
> wells(dot)oliver(at)gmail(dot)com
>
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net