Re: 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: Re: How can I save/load all triggers/stored procedures from a file?
Date: 2003-04-01 08:32:25
Message-ID: 15f19d61.0304010032.8ba1039@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.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2003-04-01 09:47:37 Re: How can I save/load all triggers/stored procedures from a file?
Previous Message Nigel J. Andrews 2003-04-01 07:29:56 lo_copy()