| 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
|
| 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 |