Re: pg_get_procdef ? - Mailing list pgsql-general

hubert depesz lubaczewski <depesz@depesz.com> writes:
> and check the queries. getting function definition from there should be
> simple.

Check getddl to see how much simple it is:

  https://labs.omniti.com/labs/pgtreats/wiki/getddl
  http://pgsql.tapoueh.org/getddl/
  http://pgsql.tapoueh.org/getddl/sql/function.body.sql

The Omiti version will output a single file with the objects in there,
the other version will split the objects each in its own file in
directories, to be svn / git friendly.

With the python version:
  ./getddl.py -f -F fun_dir -d db -h host -p port -U user

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support