Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-fr-generale by date

Next:From: Stéphane BUNELDate: 2007-04-14 12:59:41
Subject: Re: triggers
Previous:From: Stephane BortzmeyerDate: 2007-04-12 07:28:39
Subject: Re: Trigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group