X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 062C04758F1 for ; Fri, 21 Feb 2003 08:26:20 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 79899-06 for ; Fri, 21 Feb 2003 08:26:09 -0500 (EST) Received: from mta01-svc.ntlworld.com (mta01-svc.ntlworld.com [62.253.162.41]) by postgresql.org (Postfix) with ESMTP id DA3EB475B07 for ; Fri, 21 Feb 2003 08:25:35 -0500 (EST) Received: from [80.2.138.220] by mta01-svc.ntlworld.com (InterMail vM.4.01.03.27 201-229-121-127-20010626) with ESMTP id <20030221132538.EYAL22267.mta01-svc.ntlworld.com@[80.2.138.220]> for ; Fri, 21 Feb 2003 13:25:38 +0000 From: "Graham Vickrage" To: Subject: How do I view triggers Date: Fri, 21 Feb 2003 13:24:25 -0000 Message-ID: <008f01c2d9ac$90be5430$6d00000a@GVICKRAGE> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/486 X-Sequence-Number: 11884 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