Columns view? (Finding column names for a table)

Поиск
Список
Период
Сортировка
От Steve Midgley
Тема Columns view? (Finding column names for a table)
Дата
Msg-id 20080206203334.8B2B52E01F8@postgresql.org
обсуждение исходный текст
Ответы Re: Columns view? (Finding column names for a table)  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-sql
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.

However, if I execute "select columns;" I get a not found error. I'm 
sure there's some simple explanation - I'm interested specifically in 
listing the column names of a specific table (in Pg 8.2). The manual 
SQL I've developed is (where [table_name] is the table I want columns 
for):
         select pg_attribute.attname, * from pg_attribute          join pg_class on pg_class.oid =
pg_attribute.attrelid       where          pg_class.relname = '[table_name]'          and          attnum > 0
andatttypid > 0
 

Not pretty but seems to work. Of course if there were a view that 
encapsulated this and future-proofed it, that'd be much nicer.

Any assistance is appreciated! Thanks,

Steve



В списке pgsql-sql по дате отправления:

Предыдущее
От: TJ O'Donnell
Дата:
Сообщение: Create Table xtest (like xtype)
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Columns view? (Finding column names for a table)