Re: Columns view? (Finding column names for a table)

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