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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
