Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 55C4447580E for ; Fri, 16 Aug 2002 19:08:17 -0400 (EDT) Received: from marsha.pcisys.net (marsha.pcisys.net [216.229.32.146]) by postgresql.org (Postfix) with ESMTP id 9F1B04750F5 for ; Fri, 16 Aug 2002 19:08:16 -0400 (EDT) Received: from [208.202.106.214] (moe1.meg106-214.cos.pcisys.net [208.202.106.214]) by marsha.pcisys.net (8.12.5/8.12.5) with ESMTP id g7GN8H4O013290 for ; Fri, 16 Aug 2002 17:08:18 -0600 (MDT) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Fri, 16 Aug 2002 17:08:19 -0600 Subject: Re: [Fwd: Names of columns used by primary key] From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <3D5D4541.3090706@paradise.net.nz> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/46 X-Sequence-Number: 1391 on 8/16/02 12:32 PM, kgordon@paradise.net.nz purportedly said: > Question for pqsql-php mail list: > How can I determine the names of the columns that make up the primary > key in a postgresql table? > Your help would be appreciated. What you need is found in the system catalogs. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"