| From: | "Michael Dengler" <michael(dot)dengler(at)gmail(dot)com> |
|---|---|
| To: | "Jon Sime" <jsime(at)mediamatters(dot)org> |
| Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: how to output column names |
| Date: | 2007-04-19 19:25:58 |
| Message-ID: | e8733d090704191225j5e479e97n1b75c55a2c07423e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Perfect! thanks for the help!.
Mike
On 4/19/07, Jon Sime <jsime(at)mediamatters(dot)org> wrote:
>
> 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/
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Tsukinovsky | 2007-04-19 19:29:52 | postgres: 100% CPU utilization |
| Previous Message | Jon Sime | 2007-04-19 17:49:43 | Re: how to output column names |