On Fri, Aug 15, 2008 at 5:59 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Ian Harding" <harding.ian@xxxxxxxxx> writes: >> Is there any way to tell if a trigger or triggers are disabled on a >> table? I was updating some data a week or two ago and must have >> forgotten to re-enable the triggers. Took me a little while to figure >> out. \d tablename didn't tell me, nor did \d+ tablename. > >> This is on 8.2.3. > > FWIW, 8.3's psql knows about showing this in \dt. > Yet another reason to upgrade.. Thanks! - Ian
