Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 47C8A475458 for ; Sun, 3 Nov 2002 13:19:43 -0500 (EST) Received: from krusty.pcisys.net (krusty.pcisys.net [216.229.32.178]) by postgresql.org (Postfix) with ESMTP id A2DD2475425 for ; Sun, 3 Nov 2002 13:19:42 -0500 (EST) Received: from [216.229.45.5] (moe.rbe45-5.cos.pcisys.net [216.229.45.5]) by krusty.pcisys.net (8.12.5/8.12.5) with ESMTP id gA3IJbue019544 for ; Sun, 3 Nov 2002 11:19:42 -0700 (MST) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.0.4 Date: Sun, 03 Nov 2002 11:19:37 -0700 Subject: Re: Column names From: Keary Suska To: Postgres-PHP Message-ID: In-Reply-To: <1036315305.21527@mail4.wannafind.dk> 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: 200211/2 X-Sequence-Number: 1584 on 11/3/02 2:26 AM, kelvin@varst.dk purportedly said: > When I make a simple "SELECT * FROM table;" query, is there somewhere in > that query I can find the names of the columns? What exactly do you need to do? The column names are available to PHP. You can determine them dynamically by using pg_fetch_assoc() and applying array_keys() to the resulting aray. Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet"