Re: Scripting function definitions as SQL?

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

Does pg_dump not do what you want?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Postgres User"
Дата:
Сообщение: Scripting function definitions as SQL?
Следующее
От: "Postgres User"
Дата:
Сообщение: Re: Scripting function definitions as SQL?