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

[Thomas Kellerer]

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



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend