Re: table column information

On Tue, 2004-05-18 at 17:53, Robert Treat wrote:
> A little late to the party, but it seems worth mentioning that this
> information is also available in the information_schema, which has the
> benefits of being sql complient, stable across releases, and keeps you out of
> the system catalogs. for example:
>
> cms74=# select column_name from information_schema.columns where table_name =
> 'current_downloads';
> column_name
> -------------
> start_time
> entity_id
> (2 rows)
>
> for more on information schema check out
> http://www.postgresql.org/docs/7.4/interactive/information-schema.html
>
> Robert Treat

That looks like a nice way to get that information. Thanks for another
good tip.

--
Scot L. Harris <webid(at)cfl(dot)rr(dot)com>