Re: How can I describe a table with select * ...

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: How can I describe a table with select * ...
Дата
Msg-id Pine.LNX.4.44.0206261243270.2475-100000@cm-lcon-46-187.cm.vtr.net
обсуждение исходный текст
Ответ на How can I describe a table with select * ...  (Jiaqing Wang <jjw72@yahoo.com>)
Список pgsql-general
Jiaqing Wang dijo:

> Hi,
> I'm fairly new here, and new to PostgreSQL, I recently run into a
> problem. As you all know that you can do "\d table_name" to describe a
> table in psql. However, I need to get the same result via regular SQL
> query which can be sent to server via many client interface. I know
> these info must be stored somewhere in the system tables but seem to
> have failed to put together the whole picture, can anyone help? any
> direction would be greatly appreciated.

Try psql -E. I will show you the queries psql is doing behind your back.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"La verdad no siempre es bonita, pero el hambre de ella si"




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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: How to run multi-processor question
Следующее
От: Elaine Lindelef
Дата:
Сообщение: Re: What is a tuple?