Thread: Re: Where are User Defined Functions Stored?

Re: Where are User Defined Functions Stored?

From
Alexander Solianic
Date:
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