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

Поиск
Список
Период
Сортировка
От mihai11@mailcity.com (Razvan)
Тема Re: How can I save/load all triggers/stored procedures from a file?
Дата
Msg-id 15f19d61.0304010032.8ba1039@posting.google.com
обсуждение исходный текст
Ответ на How can I save/load all triggers/stored procedures from a file?  (mihai11@mailcity.com (Razvan))
Список 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 по дате отправления:

Предыдущее
От: "James Pharaoh"
Дата:
Сообщение: PHP deadlock detection
Следующее
От: Steven Singer
Дата:
Сообщение: Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose