Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VCtM0-0003tG-9x for pgsql-admin@arkaria.postgresql.org; Fri, 23 Aug 2013 15:32:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VCtLz-0000MK-Ks for pgsql-admin@arkaria.postgresql.org; Fri, 23 Aug 2013 15:32:47 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VCtLy-0000Lp-BD for pgsql-admin@postgresql.org; Fri, 23 Aug 2013 15:32:46 +0000 Received: from mail-wi0-x22d.google.com ([2a00:1450:400c:c05::22d]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VCtLr-0006Wb-99 for pgsql-admin@postgresql.org; Fri, 23 Aug 2013 15:32:45 +0000 Received: by mail-wi0-f173.google.com with SMTP id ey16so906107wid.6 for ; Fri, 23 Aug 2013 08:32:37 -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=eOpu2b7PsUhFaU17dHQwHD09M4hRDKVClUqqxeaLSNc=; b=of74o5pc1EP+v8cUrj27cQv/Qm/o2Z9pAt9i2MeVu2YHKNe6VvlhiZhHFHN/tU3mqs fTClVhsabZXsH68KLHXY+dVapEl5+Sx8Me4VMIFuLaoIyIcq1RTyTA/5uDI+OLHuD5Jl v9xrAqKmLVgyfo1PD65S46ujhShS/aP3iveDBH0wNO3CUQxGTj92mIyp2UfyQ2EttI97 M715jQQLB7CQ00LbPPTZP/aPQ1sZHVG270v3ML3JKCXURDSeX1H+oCl0u16ZfBuXyStF o2oriffQnSUt3xXUCUoHbMt2BpTDLGMSMdkIZ/wNOOjWKlXxrytJf95tu6bz+ntbd/Dv XfOA== X-Received: by 10.180.189.9 with SMTP id ge9mr133997wic.52.1377271957293; Fri, 23 Aug 2013 08:32:37 -0700 (PDT) Received: from [192.168.1.3] ([151.77.181.153]) by mx.google.com with ESMTPSA id li9sm578907wic.4.1969.12.31.16.00.00 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 23 Aug 2013 08:32:36 -0700 (PDT) Message-ID: <52178080.7010908@gmail.com> Date: Fri, 23 Aug 2013 17:32:16 +0200 From: Salvatore Barone User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130704 Icedove/17.0.7 MIME-Version: 1.0 To: bricklen CC: "pgsql-admin@postgresql.org" Subject: Re: question on the information_schema References: <52177664.5030908@gmail.com> <1377270150147-5768391.post@n5.nabble.com> <52177BC0.1060007@gmail.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------000500080001080707070305" X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------000500080001080707070305 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit This is the output of \d from psql. I logged in as "ssaa" Lista delle relazioni Schema | Nome | Tipo | Proprietario | Dimensione | Descrizione --------+----------------------------+---------+--------------+------------+------------- public | acquisti_persona_fisica | tabella | platinet | 8192 bytes | public | acquisti_persona_giuridica | tabella | platinet | 0 bytes | public | articolo | tabella | platinet | 8192 bytes | public | fornitore | tabella | platinet | 0 bytes | public | giacenza | tabella | platinet | 0 bytes | public | persona_fisica | tabella | platinet | 8192 bytes | public | persona_giuridica | tabella | platinet | 8192 bytes | (7 righe) And this is the output of show search_path; search_path ---------------- "$user",public (1 riga) -- Saluti, Salvatore Barone --------------000500080001080707070305 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit This is the output of \d from psql. I logged in as "ssaa"

                                  Lista delle relazioni
 Schema |            Nome            |  Tipo   | Proprietario | Dimensione | Descrizione
--------+----------------------------+---------+--------------+------------+-------------
 public | acquisti_persona_fisica    | tabella | platinet     | 8192 bytes |
 public | acquisti_persona_giuridica | tabella | platinet     | 0 bytes    |
 public | articolo                   | tabella | platinet     | 8192 bytes |
 public | fornitore                  | tabella | platinet     | 0 bytes    |
 public | giacenza                   | tabella | platinet     | 0 bytes    |
 public | persona_fisica             | tabella | platinet     | 8192 bytes |
 public | persona_giuridica          | tabella | platinet     | 8192 bytes |
(7 righe)

And this is the output of  show search_path;

 search_path  
----------------
 "$user",public
(1 riga)




-- 
Saluti,
Salvatore Barone
--------------000500080001080707070305--