gt; --
> *From:* Scott Mead [sco...@openscg.com]
> *Sent:* Wednesday, March 27, 2013 1:49 PM
> *To:* Raghavendra
> *Cc:* Keith Ouellette; pgsql-admin@postgresql.org
> *Subject:* Re: [ADMIN] Dump only functions
>
> On Wed, Mar 27, 2013
?
Thanks again for everyones help.
From: Scott Mead [sco...@openscg.com]
Sent: Wednesday, March 27, 2013 1:49 PM
To: Raghavendra
Cc: Keith Ouellette; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Dump only functions
On Wed, Mar 27, 2013 at 1:43 PM, Raghavendra
On Wed, Mar 27, 2013 at 1:43 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> On Wed, Mar 27, 2013 at 10:53 PM, Keith Ouellette <
> keith.ouelle...@airgas.com> wrote:
>
>> Is there a way to dump only functions to a directory with each function
>> as its own file in SQL format?
>>
> AF
Try something like this:
for a in `echo "SELECT p.proname
FROM pg_catalog.pg_proc p
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = p.pronamespace
WHERE pg_catalog.pg_function_is_visible(p.oid)
AND n.nspname <> 'pg_catalog'
AND n.nspname <> 'information_schema'"|psql -A -t test`;
do echo "SELECT pg
On Wed, Mar 27, 2013 at 10:53 PM, Keith Ouellette <
keith.ouelle...@airgas.com> wrote:
> 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-de
Is there a way to dump only functions to a directory with each function as its
own file in SQL format?
Thanks,
Keith
