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

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

Razvan schrieb:

Hi

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.

I have just updated my SQL Workbench to support exactly this. It is a
Java based frontend to any JDBC database. It's free and if you want, you
can have a look at www.kellerer.org/workbench

Cheers
Thomas

Thomas Kellerer wrote:

Razvan schrieb:

Hi

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.

I have just updated my SQL Workbench to support exactly this. It is a
Java based frontend to any JDBC database. It's free and if you want, you
can have a look at www.kellerer.org/workbench

Cheers
Thomas

Nice tool. It looks really useful. I had not seen that one before. Thanks.

I have just updated my SQL Workbench to support exactly this. It is a
Java based frontend to any JDBC database. It's free and if you want, you
can have a look at www.kellerer.org/workbench

The screen shots are nice; I'll definitively take a look.
The advantage over psql is that this front-end works in graphic mode.

Regards,
Razvan M