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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Trigger



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.



  • References:

Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group