Received: from summersault.com (nollie.summersault.com [199.120.185.41]) by hub.org (8.9.3/8.9.3) with SMTP id XAA31203 for ; Sun, 14 Nov 1999 23:55:58 -0500 (EST) (envelope-from mark@summersault.com) Received: (qmail 41121 invoked from network); 15 Nov 1999 04:56:57 -0000 Received: from mark.summersault.com (HELO summersault.com) (199.120.185.113) by nollie.summersault.com with SMTP; 15 Nov 1999 04:56:57 -0000 Message-ID: <382F925C.31358F09@summersault.com> Date: Sun, 14 Nov 1999 23:57:15 -0500 From: Mark Stosberg Reply-To: mark@summersault.com Organization: Summersault X-Mailer: Mozilla 4.7 (Macintosh; I; PPC) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: how can tell if a column is a primary key? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! I'm writing some perl code to access arbitrary Postgres tables. As part of this, I would like to be to tell if a given column is a primary key. Given a table and a column name, is there is a select statement I can run on the systems tables to tell me whether or not it's a primary key? Thanks. -mark -- <<-------------------------------------------------------------->> personal website < Summersault Website Design http://mark.stosberg.com/ > http://www.summersault.com/