Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 7435F9FB482 for ; Thu, 19 Apr 2007 14:49:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 59412-05 for ; Thu, 19 Apr 2007 14:49:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 0290E9FB42B for ; Thu, 19 Apr 2007 14:49:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.mediamatters.org (mail.mediamatters.org [63.240.197.71]) by svr4.postgresql.org (Postfix) with ESMTP id 5001B5AF024 for ; Thu, 19 Apr 2007 17:49:39 +0000 (GMT) Received: from [10.1.0.133] (63-146-242-133.dia.static.qwest.net [63.146.242.133]) by mail.mediamatters.org (Postfix) with ESMTP id 2177696C0F0; Thu, 19 Apr 2007 13:49:21 -0400 (EDT) Message-ID: <4627ABB7.8060306@mediamatters.org> Date: Thu, 19 Apr 2007 13:49:43 -0400 From: Jon Sime Organization: Media Matters for America User-Agent: Thunderbird 2.0.0.0 (X11/20070419) MIME-Version: 1.0 To: Michael Dengler Cc: pgsql-performance Subject: Re: how to output column names References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.035 tagged_above=0 required=5 tests=AWL=0.034, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200704/348 X-Sequence-Number: 24225 Michael Dengler wrote: > Hi, > > Is there a query I can perform (perhaps on a system table) to return all > of the column names (ONLY the column names) for a given DB? (I seem to > remember doing this before but cant remember how) > > Thanks > > Mike > The 'columns' view in information_schema should do the trick for you. -Jon -- Senior Systems Developer Media Matters for America http://mediamatters.org/