Re: Dump only functions
От | Raghavendra |
---|---|
Тема | Re: Dump only functions |
Дата | |
Msg-id | CA+h6AhjvvTx_KSC7yivxaF_Wftnc7qAKZP2wJL8VWG4Wd5+ROQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Dump only functions (Keith Ouellette <Keith.Ouellette@Airgas.com>) |
Ответы |
Re: Dump only functions
Re: Dump only functions |
Список | pgsql-admin |
Is there a way to dump only functions to a directory with each function as its own file in SQL format?
AFAIK, there's no direct way to dump each function to a separate file. However, you can use system-defined function or system table to retrieve function structure and then write them to separate file each by using bash or perl scripting.
select prosrc from pg_proc where proname='foo';
or
select pg_get_functiondef('foo(integer)'::regprocedure::oid);
or
Use other sources like pg_extractor tools.
---
Regards,
Raghavendra
EnterpriseDB Corporation
Thanks,
Keith
В списке pgsql-admin по дате отправления: