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 object "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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
