Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0F9C52E3689 for ; Mon, 17 Dec 2007 13:47:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 16049-05 for ; Mon, 17 Dec 2007 13:47:13 -0400 (AST) Received: from web31801.mail.mud.yahoo.com (web31801.mail.mud.yahoo.com [68.142.207.64]) by postgresql.org (Postfix) with SMTP id 8B1E12E3651 for ; Mon, 17 Dec 2007 13:47:23 -0400 (AST) Received: (qmail 81426 invoked by uid 60001); 17 Dec 2007 17:47:22 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=iK50tDPnXVV6a3NeZgZHjGgd2n21JFsZIuCkDoeLcSaoE0PI/IwwIMECrsO8eMtFWmawtGehIj1yJuuth3CIhWQgMFp7TdYX3kNV4X8OLRW1DjlSct+WC0JJMtJK2+LhmSDeMcQQW5ogwzee88VMlJp+4jjSCL1HdOYk7JnjW8M=; X-YMail-OSG: L1nsfCAVM1lYU0NIRE9zXKtZpV9cwll2D8.khxAQblJlTjcpc89eMO3EeL2Ad08CcrjKlH3Mag-- Received: from [12.180.237.138] by web31801.mail.mud.yahoo.com via HTTP; Mon, 17 Dec 2007 09:47:22 PST X-Mailer: YahooMailWebService/0.7.162 Date: Mon, 17 Dec 2007 09:47:22 -0800 (PST) From: Richard Broersma Jr Subject: Re: Describe Table To: pgsql-sql@postgresql.org, danap@dandymadeproductions.com In-Reply-To: <20071217165211.E18222E3202@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <514977.80789.qm@web31801.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/94 X-Sequence-Number: 29786 --- 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.