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

Re: Trigger

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: ncosset <ncosset(at)emix(dot)fr>
Cc: pgsql-fr-generale(at)postgresql(dot)org
Subject: Re: Trigger
Date: 2007-04-12 07:28:39
Message-ID: 20070412072839.GA26746@nic.fr (view raw or flat)
Thread:
Lists: pgsql-fr-generale
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;

[L'autocomplétion est très pratique pour découvrir les tables de la
série pg_*.]

> les codes de l'ensemble des trigger 

pg_dump --schema-only $DATABASE

Bon, cela recupère plein d'autres choses mais au moins on a tous les
triggers.


In response to

  • Trigger at 2007-04-11 07:24:49 from ncosset

Responses

  • Re: Trigger at 2007-04-14 08:12:26 from spam wearegeeks

pgsql-fr-generale by date

Next:From: spam wearegeeksDate: 2007-04-14 08:12:26
Subject: Re: Trigger
Previous:From: Sébastien DinotDate: 2007-04-11 21:12:47
Subject: [RESOLU] Re: Pb de type composite

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