Re: Columns view? (Finding column names for a table) - Mailing list pgsql-sql

Steve Midgley wrote on 06.02.2008 21:33:
> Hi,
> 
> I see this documentation item but can't figure out how to use it:
> 
> http://www.postgresql.org/docs/8.2/interactive/infoschema-columns.html
> 
>> The view columns contains information about all table columns (or view 
>> columns) in the database.

select column_name
from information_schema.columns
where table_name = 'table_name'

works for me.

Thomas