Re: Where are User Defined Functions Stored? - Mailing list pgsql-general

From Alexander Solianic
Subject Re: Where are User Defined Functions Stored?
Date
Msg-id 3b389750@news.telekom.ru
Whole thread Raw
List 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 by date:

Previous
From: "Sergei Pohilko"
Date:
Subject: Cast varchar to interval in plpgsql
Next
From: Sterling
Date:
Subject: SELECT something NOT EQUAL to????