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" <akretschmer@spamfence.net> wrote in message
news:20100320081646.GA26868@tux...
> Carlo Stonebanks <stonec.register@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 would like to search and replace.
>
> All functions are stored in pg_catalog.pg_proc, you can search the
> column prosrc for your network paths.
>
> And you can get the whole function-definition with pg_get_functiondef.
>
>
> Okay. Now you can run this select:
>
> select 'select pg_get_functiondef (' || oid || ');' from pg_proc where
> prosrc ~ 'network path';
>
> The result can you use to run as commands to retrieve all
> function-definitions.
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect. (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly." (unknown)
> Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>