From: Richard Broersma Jr <rabroersma@yahoo.com>
To: pgsql-sql@postgresql.org
To: danap@dandymadeproductions.com
Subject: Re: Describe Table
Date: Mon, 17 Dec 2007 09:47:22 -0800 (PST)
Message-ID: <514977.80789.qm@web31801.mail.mud.yahoo.com> (raw)
In-Reply-To: <20071217165211.E18222E3202@postgresql.org>
--- 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 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rabroersma@yahoo.com, danap@dandymadeproductions.com
Subject: Re: Describe Table
In-Reply-To: <514977.80789.qm@web31801.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox