Re: question on the information_schema - Mailing list pgsql-admin

From bricklen
Subject Re: question on the information_schema
Date
Msg-id CAGrpgQ_Mg60DOdAS6VaNr5Q-DKFysB3x3Y1Skx8qR6AGfnHUBA@mail.gmail.com
Whole thread Raw
In response to Re: question on the information_schema  (Salvatore Barone <salvator.barone@gmail.com>)
List pgsql-admin

On Fri, Aug 23, 2013 at 8:02 AM, Salvatore Barone <salvator.barone@gmail.com> wrote:
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.

See David Johnston's response, I think that might be the reason why you are not seeing anything (no tables to show columns of).

pgsql-admin by date:

Previous
From: Salvatore Barone
Date:
Subject: Re: question on the information_schema
Next
From: Salvatore Barone
Date:
Subject: Re: question on the information_schema