Re: Trigger

From: spam wearegeeks <spam(at)wearegeeks(dot)info>
To: pgsql-fr-generale(at)postgresql(dot)org
Subject: Re: Trigger
Date: 2007-04-14 08:12:26
Message-ID: 46208CEA.2030200@wearegeeks.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

Stephane Bortzmeyer a écrit :
> On Wed, Apr 11, 2007 at 09:24:49AM +0200,
> ncosset <ncosset(at)emix(dot)fr> wrote
> a message of 20 lines which said:
>
>
>> J'aimerai récupérer la liste
>>
>
> SELECT * FROM pg_trigger;
>

En complément, pour avoir le contenu des triggers ne suffirait-il pas de
faire quelque chose du genre :

|SELECT pg_get_triggerdef(oid) FROM pg_trigger

?

Cordialement,
||
Benjamin
|

In response to

  • Re: Trigger at 2007-04-12 07:28:39 from Stephane Bortzmeyer

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Stéphane BUNEL 2007-04-14 12:59:41 Re: triggers
Previous Message Stephane Bortzmeyer 2007-04-12 07:28:39 Re: Trigger