Re: how to output column names - Mailing list pgsql-performance

From Jon Sime
Subject Re: how to output column names
Date
Msg-id 4627ABB7.8060306@mediamatters.org
Whole thread Raw
In response to how to output column names  ("Michael Dengler" <michael.dengler@gmail.com>)
Responses Re: how to output column names  ("Michael Dengler" <michael.dengler@gmail.com>)
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: how to output column names
Next
From: "Michael Dengler"
Date:
Subject: Re: how to output column names