Re: howto get column names of tables in a script..

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: howto get column names of tables in a script..
Дата
Msg-id 20021002104736.GA6875@svana.org
обсуждение исходный текст
Ответ на howto get column names of tables in a script..  (jerome <jerome@gmanmi.tv>)
Список pgsql-general
On Wed, Oct 02, 2002 at 06:00:59PM +0800, jerome wrote:
> im using tcl a my scirpting languange is there a possibility of getting column
> names of a table?
>
> pg_tables only show the table names...
>
> my purpose is for a report page w/c would dynamically show table column names
> which would be presented in a html table format....

If you use psql -E and do a \d tablename you will see that the relevent
table is pg_attributes.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

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

Предыдущее
От: jerome
Дата:
Сообщение: howto get column names of tables in a script..
Следующее
От: Elielson Fontanezi
Дата:
Сообщение: PL/SQL Developer and TOAD