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@xxxxxxxxxx>
