Hi Tony,
Thanks VERY much! That got me on my way. I'm going to try and convert this to a
PG stored function, Since you know that the script has limitations, you or
othres reading might want to know the ones I've found:
1) Regardless of what you set the schema to, the only ones that are dumped
Afaik no, you can make a schema-dump and extract the function
declarations from the dump.
Yeah, that's what I was doing. Bloody tedious. Thanks anyway!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Carlo Stonebanks stonec.regis...@sympatico.ca writes:
Afaik no, you can make a schema-dump and extract the function
declarations from the dump.
Yeah, that's what I was doing. Bloody tedious. Thanks anyway!
It seems like it could be automated.
pg_dump -Fc -s mydb mydb.dump
On Sat, Mar 20, 2010 at 11:09 PM, Carlo Stonebanks
stonec.regis...@sympatico.ca wrote:
Is pg_get_functiondef an 8.4 appears to be an 8.4 function?
I don't see it in the 8.3 documentation and the servers in question are all
8.3.
Any alternatives for 8.3? pg_proc has the code body, but not
Is pg_get_functiondef an 8.4 appears to be an 8.4 function?
I don't see it in the 8.3 documentation and the servers in question are all
8.3.
Any alternatives for 8.3? pg_proc has the code body, but not the function
declaration, etc.
Andreas Kretschmer akretsch...@spamfence.net wrote in
In response to Carlo Stonebanks :
Is pg_get_functiondef an 8.4 appears to be an 8.4 function?
Yes, new since 8.4.
I don't see it in the 8.3 documentation and the servers in question are all
8.3.
Any alternatives for 8.3? pg_proc has the code body, but not the function
declaration,
I'd like to dump to text the full SQL required to create/replace all
user-defined functions within a specific schema - but JUST the function
declarations.
We are doing server migration and there are some network paths in the code I
would like to search and replace.
Carlo
--
Sent via
Carlo Stonebanks stonec.regis...@sympatico.ca wrote:
I'd like to dump to text the full SQL required to create/replace all
user-defined functions within a specific schema - but JUST the function
declarations.
We are doing server migration and there are some network paths in the
code I