Re: Where are User Defined Functions Stored?

From: Alexander Solianic <solianic(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Where are User Defined Functions Stored?
Date: 2001-06-26 14:11:37
Message-ID: 3b389750@news.telekom.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Urlichs 2001-06-26 14:13:35 Re: More Red Hat information
Previous Message Alexander Solianic 2001-06-26 14:10:09 Re: JDBC and SQL