How can I save/load all triggers/stored procedures from a file?

From: mihai11(at)mailcity(dot)com (Razvan)
To: pgsql-general(at)postgresql(dot)org
Subject: How can I save/load all triggers/stored procedures from a file?
Date: 2003-03-21 16:05:19
Message-ID: 15f19d61.0303210805.761643b4@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

Is it possible to save/load all triggers from a text file? That
would really help the development; modifying/reloading a trigger would
be much easier.

Also, how can I see the body of a trigger that is already in
the database? If I do "\d <table_name>" I get the name of the trigger.
What should I do to see the body - I mean what you have typed when you
have created the trigger.

Regards,
Razvan M

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel R. Anderson 2003-03-21 16:05:40 Re: Posts get losts
Previous Message Doug McNaught 2003-03-21 15:43:39 Re: rules problem