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