Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5BIeLE35831 for ; Mon, 11 Jun 2001 14:40:21 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f5BIeH005953; Mon, 11 Jun 2001 14:40:17 -0400 (EDT) To: Sandro Dentella cc: pgsql-interfaces@postgresql.org Subject: Re: How to determine PRIMARY KEYS In-reply-to: <20010611184617.A6328@bluff.diade.it> References: <20010611184617.A6328@bluff.diade.it> Comments: In-reply-to Sandro Dentella message dated "Mon, 11 Jun 2001 18:46:17 +0200" Date: Mon, 11 Jun 2001 14:40:17 -0400 Message-ID: <5950.992284817@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/47 X-Sequence-Number: 1710 Sandro Dentella writes: > Here is what I do: Wouldn't it be easier just to look for the pg_index row (if any) that has indisprimary = true? regards, tom lane