Where are PL/pgsql definitions kept?
Hi,
I just upgraded to 7.4.2 today...I have started looking at PL/PGsql
functions
and noticed that the pg_dumpall and pg_dump commands are able to
recover the
text for the function definitions.
I have examined ( I think ) every table in my catalog and have not been
able
to find the text definition of my PL/PGsql function.
Is it possible to recover the text of a function definition from within
postgresql?
Thanks,
Jerry
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
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:
Show quoted text
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
On Friday 12 March 2004 21:12, Jerry LeVan wrote:
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.
That's probably because you usually define your functions
CREATE FUNCTION foo ... AS '
blah
So the first character would be a newline.
--
Richard Huxton
Archonet Ltd