| From: | "Mark Soper" <markasoper(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Dynamically generating DDL for postgresql object |
| Date: | 2007-06-15 18:31:41 |
| Message-ID: | BAY113-DAV682FC82C40E5F4E830DEEC01E0@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'd like to dynamically generate a SQL script that pulls together complete
DDL (CREATE, ALTER, etc.) for specific objects (especially constraints) in
my PostgreSQL 8 database. I want to use this for our development project's
schema migration process, which involves dumping the data, making schema
changes, recreating the database, temporarily removing constraints,
restoring the data, and re-applying the constraints (this last step requires
the dynamic DDL described above).
I've noticed that pgAdmin's "DDL Report" feature can retrieve this DDL for
many types of objects - not sure how much work it has to do to build the SQL
it's displaying here. But I haven't seen anything about getting this
directly from the database using SQL , psql, etc. I've only seen reference
to this as a proposed project on the PostgreSQL
<http://www.postgresql.org/developer/summerofcode.html> Google SoC page
Anyone know how to get object DDL SQL through a script? Ideas on
alternative approaches would also be appreciated.
Thanks,
Mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2007-06-15 18:35:41 | Re: vacuum and postgresql.conf settings |
| Previous Message | MC Moisei | 2007-06-15 18:30:26 | Re: Postmaster processes taking all the CPU |