From: | Alvaro Herrera <alvherre(at)atentus(dot)com> |
---|---|
To: | Jiaqing Wang <jjw72(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How can I describe a table with select * ... |
Date: | 2002-06-26 16:44:32 |
Message-ID: | Pine.LNX.4.44.0206261243270.2475-100000@cm-lcon-46-187.cm.vtr.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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"
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Conway | 2002-06-26 17:04:22 | Re: How to run multi-processor question |
Previous Message | Bill Moran | 2002-06-26 16:18:33 | Re: How to run multi-processor question |