On Sat, Mar 20, 2010 at 11:09 PM, Carlo Stonebanks <stonec.register@xxxxxxxxxxxx> 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 the function declaration, etc.
I've attached a simple perl script to dump all functions per schema from a database. I won't claim this is perfect, but it does the trick for me.
Works with 8.3. If you have 2 functions called public.foo, it will put them in public/foo.sql with CREATE OR REPLACE FUNCTION formatting around it.
Hope this is useful to others.
Tony Wasson
Attachment:
dump-all-functions.pl
Description: Binary data
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
