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 09CA99FA5DD for ; Fri, 9 Jun 2006 17:20:28 -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 84807-02 for ; Fri, 9 Jun 2006 17:20:18 -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 C8DD59FA1A8 for ; Fri, 9 Jun 2006 17:20:18 -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 k59KKGJx024471; Fri, 9 Jun 2006 16:20:16 -0400 (EDT) To: "Jim C. Nasby" cc: pgsql-hackers@postgresql.org Subject: Re: List schema contents In-reply-to: <20060609193356.GC57289@pervasive.com> References: <20060609193356.GC57289@pervasive.com> Comments: In-reply-to "Jim C. Nasby" message dated "Fri, 09 Jun 2006 14:33:57 -0500" Date: Fri, 09 Jun 2006 16:20:16 -0400 Message-ID: <24470.1149884416@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/465 X-Sequence-Number: 84698 "Jim C. Nasby" writes: > I'd like to propose that the behavior of \d schemaname. be changed to > match > set search_path = schemaname > \d I'm not sure what your reasoning is here, but AFAICS this would move the behavior away from what you say you want. What exactly have you got in mind, and why? In particular, why do you think that "\d schemaname." doesn't already produce exactly what you asked for, namely a list of the tables in that schema? The above would *not* produce such a list (counterexample: temp tables). > One problem I see is that this will break the ability to search for > tablename. via regex. You are aware of the double-quoting option in \d search patterns, no? regards, tom lane