From: | "Postgres User" <postgres(dot)developer(at)gmail(dot)com> |
---|---|
To: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Postgres User" <postgres(dot)developer(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Scripting function definitions as SQL? |
Date: | 2008-05-11 18:28:37 |
Message-ID: | b88c3460805111128s32d82a99w9c5d5994559f49ca@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Unfortunately I didn't see a way to tell pg_dump to dump only objects
of a specific type, like functions or sequences. It requires
additional coding to parse the output and that's less than ideal...
> Does pg_dump not do what you want?
On Sun, May 11, 2008 at 6:49 AM, Martijn van Oosterhout
<kleptog(at)svana(dot)org> wrote:
> On Sun, May 11, 2008 at 06:12:40AM -0700, Postgres User wrote:
> > Has anyone written a function that scripts out all the functions in a
> > database as full SQL statements (Create Function.....)
> >
> > I found the below SQL will return all the fields needed to build a SQL
> > statement, but it would take some work to combine the field values
> > correctly to get the right format. So does anyone know if the code
> > has already been written by someone else?
From | Date | Subject | |
---|---|---|---|
Next Message | Chuck Bai | 2008-05-11 18:43:23 | How to create a function with multiple RefCursor OUT parameters |
Previous Message | Martijn van Oosterhout | 2008-05-11 13:49:37 | Re: Scripting function definitions as SQL? |