X-Original-To: pgsql-hackers-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A71059FA5DD for ; Fri, 9 Jun 2006 17:55:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 85865-09 for ; Fri, 9 Jun 2006 17:55:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 0346E9FA1A8 for ; Fri, 9 Jun 2006 17:55:09 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k59Kt8Am024710; Fri, 9 Jun 2006 16:55:08 -0400 (EDT) To: "Jim C. Nasby" cc: pgsql-hackers@postgresql.org Subject: Re: List schema contents In-reply-to: <20060609202741.GF57289@pervasive.com> References: <20060609193356.GC57289@pervasive.com> <24470.1149884416@sss.pgh.pa.us> <20060609202741.GF57289@pervasive.com> Comments: In-reply-to "Jim C. Nasby" message dated "Fri, 09 Jun 2006 15:27:41 -0500" Date: Fri, 09 Jun 2006 16:55:07 -0400 Message-ID: <24709.1149886507@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/468 X-Sequence-Number: 84701 "Jim C. Nasby" writes: > What I'm looking for is what "\d" provides you, only limited to a > specific schema. "\d information_schema." (for example) doesn't provide > that; it provides the details for every table/view in > information_schema. What you're looking for is \dt, or perhaps \dtsv or one of those forms. I'd be the first to agree that the behavior of \d isn't particularly orthogonal, but it's not the pattern language that's the problem, it's the command itself. regards, tom lane