Postgres Professional
   

Re: how to output column names

From: Jon Sime
Subject: Re: how to output column names
Date: ,
Msg-id: 4627ABB7.8060306@mediamatters.org
(view: Whole thread, Raw)
In response to: how to output column names  ("Michael Dengler")
Responses: Re: how to output column names  ("Michael Dengler")
List: pgsql-performance 
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/

pgsql-performance by date:

Previous:
From: "Michael Dengler"
Date:
Subject: Re: how to output column names
Next:
From: Andrew Lazarus
Date:
Subject: index structure for 114-dimension vector