Re: Describe Table - Mailing list pgsql-sql

From Richard Broersma Jr
Subject Re: Describe Table
Date
Msg-id 514977.80789.qm@web31801.mail.mud.yahoo.com
Whole thread Raw
In response to Describe Table  (<danap@dandymadeproductions.com>)
List pgsql-sql
--- On Mon, 12/17/07, danap@dandymadeproductions.com 

> I've reviewed much of the documentation and the forums,
> but unable to seem to find a easy way to obtain the same
> thing as the 'psql \d table' through sql. I

I've never understood the information schema well enough to construct my own sql queries that provide the same useful
informationas 'psql \d'.  So instead, I cheat:
 

start psql with the '-E' option to echo all sql strings psql sends to the back-end server.

Simply copy and tailor each statement to suit your needs.

Regards,
Richard Broersma Jr.


pgsql-sql by date:

Previous
From: Colin Wetherbee
Date:
Subject: Re: Describe Table
Next
From: Tom Lane
Date:
Subject: Re: Describe Table