On Wed, Oct 27, 2010 at 11:21:43AM +0200, Marc Mamin wrote: > Hello, > > I want to export a list of procedure definitions, which seems to be a > hard nut to crack :-( > A solution could be to use a combination of pg_dump and pg_restore, but > this also requires some time investment. > It would be fine, if pg_dump could be more selective about the object to > select... > > Does anyone have a handmade solution for a pg_get_procdef function. > > I'm still on Postgres 8.3 ...
pg_dump -Fc -s + pg_restore -l | grep + pg_restore -L will be fast. if that's not good enough for you, do: psql -E \df+ function and check the queries. getting function definition from there should be simple. Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
