How do I view triggers

From: "Graham Vickrage" <graham(at)gpmd(dot)co(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: How do I view triggers
Date: 2003-02-21 13:24:25
Message-ID: 008f01c2d9ac$90be5430$6d00000a@GVICKRAGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All,

I am slightly confused as to how I view what triggers I have on a
certain table.

select * from pg_trigger

doesn't show me the trigger I have just created, but its definitely
there because when I try and create it, it gives an error that it
already exists.

TIA

Graham

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rafal Kedziorski 2003-02-21 13:30:22 good style?
Previous Message Rajesh Kumar Mallah 2003-02-21 13:08:27 Re: " Adding missing FROM-clause entry for table .... " problem.