Re: Newbie question on how to check triggers created

From: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
To: Chunky <so_excited(at)excite(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Newbie question on how to check triggers created
Date: 2000-06-12 15:23:58
Message-ID: 3945008E.DB3577A6@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Vazsonyi 2000-06-12 18:21:38 Re: Outer join in postgresql
Previous Message Chunky 2000-06-12 14:23:33 Newbie question on how to check triggers created