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@cfl.rr.com>