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
>
