Aha ... makes sense. Thank you, Tom.
Mark
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
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 object
"Mark Soper" <markasoper@hotmail.com> 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