Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 4660E6329E1 for ; Thu, 17 Jun 2010 04:45:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 23896-04 for ; Thu, 17 Jun 2010 07:45:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.hi-media-techno.com (smtp1.hi-media-techno.com [195.158.241.85]) by mail.postgresql.org (Postfix) with ESMTP id 35107632584 for ; Thu, 17 Jun 2010 04:45:08 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 9052493B9A; Thu, 17 Jun 2010 09:45:06 +0200 (CEST) Received: from smtp1.hi-media-techno.com ([127.0.0.1]) by localhost (smtp1.backbone.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id vgtwTAPHQCCf; Thu, 17 Jun 2010 09:45:06 +0200 (CEST) Received: from mail1.hi-media-techno.com (unknown [192.168.27.17]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 4DFA43863C8; Thu, 17 Jun 2010 09:45:06 +0200 (CEST) Received: from dim (unknown [83.167.62.196]) by mail1.hi-media-techno.com (Postfix) with ESMTPSA id 4446612763; Thu, 17 Jun 2010 09:45:06 +0200 (CEST) Received: by dim (Postfix, from userid 1000) id 1A1C25CF63; Thu, 17 Jun 2010 09:45:06 +0200 (CEST) From: Dimitri Fontaine To: Scott Marlowe Cc: Kevin Grittner , donghe@caltech.edu, pgsql-admin@postgresql.org Subject: Re: access to non public schema Organization: Hi-Media References: <2106.131.215.15.78.1276710977.squirrel@webmail.caltech.edu> <4C18D9BA02000025000324A2@gw.wicourts.gov> <2431.131.215.15.78.1276720865.squirrel@webmail.caltech.edu> <4C18F11302000025000324C8@gw.wicourts.gov> User-Mail-Address: dfontaine@hi-media.com Date: Thu, 17 Jun 2010 09:45:05 +0200 In-Reply-To: (Scott Marlowe's message of "Wed, 16 Jun 2010 14:53:58 -0600") Message-ID: <87mxuurtku.fsf@hi-media-techno.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/120 X-Sequence-Number: 34898 Scott Marlowe writes: >> \dn > > And if you need to see the SQL running behind the scenes, start psql > with the -E switch Or use \set ECHO_HIDDEN, which is a toggle. -- dim