Re: question on the information_schema

bricklen <bricklen@xxxxxxxxx> · Fri, 23 Aug 2013 08:04:39 -0700

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