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
"Mark Soper" <[EMAIL PROTECTED]> writes:
> Interestingly, it doesn't include some of the
> information displayed in pgAdmin (i.e. Match type, On Update, On Delete) -
pg_get_constraintdef is aware that those values are the default ...
regards, tom lane
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]
You can use pg_dump.exe to generate DDL in postgre.
see: http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html
also you might check out the app in my sig for a tool that generates
full reports/documentation about any pg database.
hth, Jesse
---
http://www.elsasoft.or
On Jun 15, 2007, at 2:31 PM, Mark Soper wrote:
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
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
