Re: Scripting function definitions as SQL?
От | Postgres User |
---|---|
Тема | Re: Scripting function definitions as SQL? |
Дата | |
Msg-id | b88c3460805111128s32d82a99w9c5d5994559f49ca@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Scripting function definitions as SQL? (Martijn van Oosterhout <kleptog@svana.org>) |
Ответы |
Re: Scripting function definitions as SQL?
|
Список | 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@svana.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?
В списке pgsql-general по дате отправления: