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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
