Received: from Mail.austin.rr.com (sm2.texas.rr.com [24.93.35.55]) by hub.org (8.10.1/8.10.1) with ESMTP id e5CFIqT45974 for ; Mon, 12 Jun 2000 11:18:52 -0400 (EDT) Received: from austin.rr.com ([24.93.36.87]) by Mail.austin.rr.com with Microsoft SMTPSVC(5.5.1877.357.35); Mon, 12 Jun 2000 10:05:08 -0500 Message-ID: <3945008E.DB3577A6@austin.rr.com> Date: Mon, 12 Jun 2000 10:23:58 -0500 From: Ed Loehr X-Mailer: Mozilla 4.7 [en] (X11; U; Linux 2.2.12-20smp i686) X-Accept-Language: en MIME-Version: 1.0 To: Chunky CC: pgsql-sql@postgresql.org Subject: Re: Newbie question on how to check triggers created References: <3944F265.4FBC1FC@excite.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200006/118 Chunky wrote: > > Could someone please enlightenment me what command in psql i should use > to show the various triggers and rules that i have created? These might work... select tgname from pg_trigger select rulename from pg_rewrite Regards, Ed Loehr