Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA96540 for ; Sat, 13 Nov 1999 14:42:25 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id OAA01498; Sat, 13 Nov 1999 14:41:12 -0500 (EST) To: Peter Eisentraut cc: Mark Stosberg , pgsql-sql@postgreSQL.org Subject: Re: [SQL] Porting MySQL's DESCRIBE and ENUM features In-reply-to: Your message of Sat, 13 Nov 1999 18:04:41 +0100 (MET) Date: Sat, 13 Nov 1999 14:41:12 -0500 Message-ID: <1496.942522072@sss.pgh.pa.us> From: Tom Lane Peter Eisentraut writes: > I would myself be interested to see how the check constraints are stored, > so I can put this into the psql \d command. You want the rcsrc column of pg_relcheck. See getTables() in pg_dump.c for an example of retrieving constraint conditions. IIRC, specialized constraints such as NOT NULL are recorded someplace else, but you probably know about those already. regards, tom lane