Re: Where are PL/pgsql definitions kept?

Ahh, thank you, the definition is actually stored in pg_proc in the
prosrc column.

I have been examining the system tables using my home brewed BiggerSQL
Postgresql Database Browser ( http://homepage.mac.com/levanj/Cocoa ) a
MacOS X utility.

BiggerSQL displays tables in a table format, one row per record.

When I displayed the pg_proc table it *appeared* that that column
contained
an empty string. Evidently the stored string starts with a new line
character.

Using the "arrow" keys to advance into the field got me to the next
line in
the definition and I was able to then see the rest of the definition ;(.

Thank you :)

Jerry

On Mar 12, 2004, at 3:47 PM, Richard Huxton wrote:

> On Friday 12 March 2004 20:12, Jerry LeVan wrote:
>>
>> Is it possible to recover the text of a function definition from
>> within
>> postgresql?
>
> In psql: \df+ my_func_name
>
> To see how that works, start psql with -E
>
> --
> Richard Huxton
> Archonet Ltd
>