Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41558=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VCstJ-0002l6-J3
 for pgsql-admin@arkaria.postgresql.org; Fri, 23 Aug 2013 15:03:09 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41558=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1VCstI-0006ys-Sb
 for pgsql-admin@arkaria.postgresql.org; Fri, 23 Aug 2013 15:03:08 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <salvator.barone@gmail.com>) id 1VCstH-0006wl-11
 for pgsql-admin@postgresql.org; Fri, 23 Aug 2013 15:03:07 +0000
Received: from mail-ee0-x22d.google.com ([2a00:1450:4013:c00::22d])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <salvator.barone@gmail.com>) id 1VCstD-0002eP-PL
 for pgsql-admin@postgresql.org; Fri, 23 Aug 2013 15:03:06 +0000
Received: by mail-ee0-f45.google.com with SMTP id c50so348730eek.18
 for <pgsql-admin@postgresql.org>; Fri, 23 Aug 2013 08:03:03 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=message-id:disposition-notification-to:date:from:user-agent
 :mime-version:to:cc:subject:references:in-reply-to:content-type;
 bh=zGrcVgqIxMoV/ENtKt4WV4QlBNqnB23KLqGSK5P2TM8=;
 b=HkHxhAE7ddnsBVBiPi81KqLOLB7lpDzS2NZu7MOr36Erw0ie9ChAJQCOxS1fh/S5cm
 TJ5jTBz0Wcsb8/rejGqUF1BqmjPFDbe/PDhpjjRTXToqt3KGncpr9reIeJyWqOM+879B
 XXE3f98L5eeckrC+LftG58eic8MUZmMbj1sKnotNQBWfBYidNxxEzshlrEQRHpAEXBOT
 pI6+7qNY33IZRbDYb46ClKIP9Vb6decOPjxA4kms/B3OIrRar6pSfsrrL6+KFIaxblfg
 EvDd2z5CYWg9dytNMCers6D1PxomsBuf4yn7pZDEwKaiAjvr4kWrW+JZdjW4JThXGW1K
 r/yg==
X-Received: by 10.15.53.73 with SMTP id q49mr123105eew.78.1377270183312;
 Fri, 23 Aug 2013 08:03:03 -0700 (PDT)
Received: from [192.168.1.3] ([151.77.181.153])
 by mx.google.com with ESMTPSA id bn13sm270716eeb.11.1969.12.31.16.00.00
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Fri, 23 Aug 2013 08:03:02 -0700 (PDT)
Message-ID: <52177997.7020306@gmail.com>
Date: Fri, 23 Aug 2013 17:02:47 +0200
From: Salvatore Barone <salvator.barone@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:17.0) Gecko/20130704 Icedove/17.0.7
MIME-Version: 1.0
To: bricklen <bricklen@gmail.com>
CC: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: question on the information_schema
References: <52177664.5030908@gmail.com>
 <CAGrpgQ_YrK=nvH2d+AvbJLdd_epnNXUOvXe=6BvroHZAVkPV3g@mail.gmail.com>
In-Reply-To: 
 <CAGrpgQ_YrK=nvH2d+AvbJLdd_epnNXUOvXe=6BvroHZAVkPV3g@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------000808000300080204060505"
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------000808000300080204060505
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

On 23/08/2013 16:57, bricklen wrote:
> select *
> from information_schema.columns
> where table_schema not in ('information_schema','pg_catalog')
Both queries, whether to send as user "ssaa", ie the user that I use
daily, return an empty table. If sending as user "postgres" instead,
they return the correct list of columns.

-- 
Saluti,
Salvatore Barone


--------------000808000300080204060505
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 23/08/2013 16:57, bricklen wrote:<br>
    </div>
    <blockquote
cite="mid:CAGrpgQ_YrK=nvH2d+AvbJLdd_epnNXUOvXe=6BvroHZAVkPV3g@mail.gmail.com"
      type="cite">select *<br>
      from information_schema.columns<br>
      where table_schema not in ('information_schema','pg_catalog')<br>
    </blockquote>
    <font size="+1"><tt>Both queries, whether to send as user "ssaa", ie
        the user that I use daily, return an empty table. If sending as
        user "postgres" instead, they return the correct list of
        columns.</tt></font><br>
    <br>
    <pre class="moz-signature" cols="72">-- 
Saluti,
Salvatore Barone</pre>
  </body>
</html>

--------------000808000300080204060505--