Aha ... makes sense. Thank you, Tom.
Mark
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 16, 2007 11:21 AM
To: Mark Soper
Cc: 'John DeSoi'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Dynamically generating DDL for postgresql obje
DEFERRABLE INITIALLY DEFERRED;
---
Mark Soper
[EMAIL PROTECTED]
25 Fairmont St #2
Cambridge, MA 02139
(617) 491-4134
-Original Message-
From: John DeSoi [mailto:[EMAIL PROTECTED]
Sent: Friday, June 15, 2007 9:51 PM
To: Mark Soper
Cc: pgsql-general@postgresql.org
Subject: Re: [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
