Re: Dump functions alone
| От | Rajan, Pavithra |
|---|---|
| Тема | Re: Dump functions alone |
| Дата | |
| Msg-id | 924146AEF992184E84C7F5A5D6E2C87D0DB40B4B@EXCHMB05.conedison.net обсуждение исходный текст |
| Ответ на | Re: Dump functions alone (Raghavendra <raghavendra.rao@enterprisedb.com>) |
| Список | pgsql-general |
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 AM
To: Rajan, Pavithra
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dump functions alone
One more thing you can also get it from pg_get_functiondef() system function.
On Wed, Feb 15, 2012 at 9:32 PM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
You have two options.
- Use contrib module pg_extractor https://github.com/omniti-labs/pg_extractor
- Use pg_proc catalog to get function definition
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 по дате отправления: