Aha ... makes sense. Thank you, Tom. Mark -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Saturday, June 16, 2007 11:21 AM To: Mark Soper Cc: 'John DeSoi'; pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] Dynamically generating DDL for postgresql object "Mark Soper" <markasoper@xxxxxxxxxxx> 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
