pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to output column names
3+ messages / 2 participants
[nested] [flat]
* how to output column names
@ 2007-04-19 17:06 Michael Dengler <michael.dengler@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Dengler @ 2007-04-19 17:06 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to output column names
@ 2007-04-19 17:49 Jon Sime <jsime@mediamatters.org>
parent: Michael Dengler <michael.dengler@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Jon Sime @ 2007-04-19 17:49 UTC (permalink / raw)
To: Michael Dengler <michael.dengler@gmail.com>; +Cc: 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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to output column names
@ 2007-04-19 19:25 Michael Dengler <michael.dengler@gmail.com>
parent: Jon Sime <jsime@mediamatters.org>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Dengler @ 2007-04-19 19:25 UTC (permalink / raw)
To: Jon Sime <jsime@mediamatters.org>; +Cc: pgsql-performance
Perfect! thanks for the help!.
Mike
On 4/19/07, Jon Sime <jsime@mediamatters.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/
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-04-19 19:25 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-19 17:06 how to output column names Michael Dengler <michael.dengler@gmail.com>
2007-04-19 17:49 ` Jon Sime <jsime@mediamatters.org>
2007-04-19 19:25 ` Michael Dengler <michael.dengler@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox