Re: How can I describe a table with select * ... - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: How can I describe a table with select * ...
Date
Msg-id Pine.LNX.4.44.0206261243270.2475-100000@cm-lcon-46-187.cm.vtr.net
Whole thread Raw
In response to How can I describe a table with select * ...  (Jiaqing Wang <jjw72@yahoo.com>)
List 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 by date:

Previous
From: Bill Moran
Date:
Subject: Re: How to run multi-processor question
Next
From: Elaine Lindelef
Date:
Subject: Re: What is a tuple?