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 D10AB9FA5E6 for ; Fri, 9 Jun 2006 16:53:02 -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 77338-09 for ; Fri, 9 Jun 2006 16:52:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82]) by postgresql.org (Postfix) with ESMTP id 042439FA1A8 for ; Fri, 9 Jun 2006 16:52:57 -0300 (ADT) Received: from localhost (mailbox.samurai.com [205.207.28.82]) by mailbox.samurai.com (Postfix) with ESMTP id B9279620D8; Fri, 9 Jun 2006 15:52:56 -0400 (EDT) X-Virus-Scanned: by amavisd-new at mailbox.samurai.com Received: from mailbox.samurai.com ([205.207.28.82]) by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new, port 10024) with LMTP id Z7coEg44cGFC; Fri, 9 Jun 2006 15:52:54 -0400 (EDT) Received: from [192.168.1.101] (unknown [69.28.112.26]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mailbox.samurai.com (Postfix) with ESMTP id 05C0061FCD; Fri, 9 Jun 2006 15:52:53 -0400 (EDT) Subject: Re: List schema contents From: Neil Conway To: "Jim C. Nasby" Cc: pgsql-hackers@postgresql.org In-Reply-To: <20060609193356.GC57289@pervasive.com> References: <20060609193356.GC57289@pervasive.com> Content-Type: text/plain Date: Fri, 09 Jun 2006 12:52:52 -0700 Message-Id: <1149882772.5471.9.camel@localhost> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/464 X-Sequence-Number: 84697 On Fri, 2006-06-09 at 14:33 -0500, Jim C. Nasby wrote: > Currently, the only way to get a listing of tables in a schema via psql > is to modify your search_path, which is both non-intuitive and a PITA. I've griped about psql's limited support for schemas in the past: http://archives.postgresql.org/pgsql-hackers/2004-10/msg00989.php http://archives.postgresql.org/pgsql-hackers/2004-11/msg00014.php I never actually got around to making any behavioral changes, but I agree there is certainly room for improvement. (The fact that archives.p.o can't properly link between threads that cross month boundaries is pretty annoying...) -Neil