Re: Where are User Defined Functions Stored?

Поиск
Список
Период
Сортировка
От Alexander Solianic
Тема Re: Where are User Defined Functions Stored?
Дата
Msg-id 3b389750@news.telekom.ru
обсуждение исходный текст
Список pgsql-general
Gary Huntress wrote:

> Suppose I write a simple function:
>
> CREATE Function foo() returns int4
> as
>     ' select 1 '
> language 'sql';
>
> Where is that code stored?    I assume its in one of the pg_* tables but I
> can't locate it.
> Using \df (in psql) I can find the names of the functions but I would like
> to get at the code for editing.
>
> --
> Regards,
> Gary "SuperID" Huntress
> =======================================================
> FreeSQL.org offering free database hosting to developers
> Visit http://www.freesql.org
>
>
>
>
Look at pg_proc table
--
Regards,
Alexander Solianic

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

Предыдущее
От: "Sergei Pohilko"
Дата:
Сообщение: Cast varchar to interval in plpgsql
Следующее
От: Sterling
Дата:
Сообщение: SELECT something NOT EQUAL to????