Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Thank you. The PGExtractor is interesting! I was trying to get all the function declaration and definition ( about 400+) by this method
pg_dump -Fc -v -s schemaname -f temp.dump yourdatabase
pg_restore -l temp.dump | grep FUNCTION >functionlist
pg_restore -L functionlist temp.dump >yourfunctions.sql
mentioned in http://archives.postgresql.org/pgsql-general/2005-10/msg01633.php
I’ll try this and your solutions as well
From: Raghavendra [mailto:raghavendra.rao@enterprisedb.com] Sent: Wednesday, February 15, 2012 11:05 AMTo: Rajan, PavithraCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] Dump functions alone
One more thing you can also get it from pg_get_functiondef() system function.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Wed, Feb 15, 2012 at 9:32 PM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
You have two options.
On Wed, Feb 15, 2012 at 6:59 PM, Rajan, Pavithra <RAJANP@oru.com> wrote:
Hello all- Is there a way to just dump functions in a schema in to a txt file/ sql file ? Thank you.
В списке pgsql-general по дате отправления: