| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org, danap(at)dandymadeproductions(dot)com |
| Subject: | Re: Describe Table |
| Date: | 2007-12-17 17:47:22 |
| Message-ID: | 514977.80789.qm@web31801.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
--- On Mon, 12/17/07, danap(at)dandymadeproductions(dot)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 information as '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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-12-17 18:03:20 | Re: Describe Table |
| Previous Message | Colin Wetherbee | 2007-12-17 17:34:27 | Re: Describe Table |