| From: | Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr> |
|---|---|
| To: | depesz(at)depesz(dot)com |
| Cc: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_get_procdef ? |
| Date: | 2010-11-02 14:50:04 |
| Message-ID: | m2tyjz3hlv.fsf@2ndQuadrant.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hubert depesz lubaczewski <depesz(at)depesz(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Clark | 2010-11-02 14:53:18 | Re: 8.4 Data Not Compatible with 9.0.1 Upgrade? |
| Previous Message | Adrian Klaver | 2010-11-02 14:42:29 | Re: 8.4 Data Not Compatible with 9.0.1 Upgrade? |