Re: question on the information_schema

2013/8/23 Salvatore Barone <salvator(dot)barone(at)gmail(dot)com>

> 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)
>

I'm stumped. I am unable to reproduce the lack of output from your query
when logged in as a non-superuser, and I can't think of a reason why you
are seeing no results. Hopefully someone else can chime in with more
suggestions or an answer.