Greetings Raj,
I found this to be helpful:
SELECT tgname, tgenabled AS tf, tgconstrname FROM pg_trigger ;
Rajesh Kumar Mallah. wrote:
> Hi ,
>
> What is the correct method of temporarily
> disabling all triggers from a table?
>
>
> also is there any command/function to show the
> trigger defination ? like pg_index_def does for indexes?
>
>
> regds
> mallah.