Re: How can I save/load all triggers/stored procedures from a file? - Mailing list pgsql-general

From mihai11@mailcity.com (Razvan)
Subject Re: How can I save/load all triggers/stored procedures from a file?
Date
Msg-id 15f19d61.0304010032.8ba1039@posting.google.com
Whole thread Raw
In response to How can I save/load all triggers/stored procedures from a file?  (mihai11@mailcity.com (Razvan))
List 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.

        To save just use a text editor - that one was easy:))
        To load a text file from psql type \i <file_name> when in interactive mode.


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

        Pg_dump would do the job.
        Thanks to all who where about to answer.




Regards,
Razvan M


pgsql-general by date:

Previous
From: "James Pharaoh"
Date:
Subject: PHP deadlock detection
Next
From: Steven Singer
Date:
Subject: Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose