> What is the correct method of temporarily
> disabling all triggers from a table?
Disable:
db=# update pg_class set reltriggers = '0' where relname = 'your_table';
Enable:
db=# update pg_class set reltriggers = (select count(*) from pg_trigger
where pg_class.oid = tgrelid) where relname = 'your_table';
>
>
> also is there any command/function to show the
> trigger defination ? like pg_index_def does for indexes?
>
Not sure.
regards,
bhuvaneswaran