Re: question on the information_schema

On Fri, Aug 23, 2013 at 8:12 AM, Salvatore Barone <salvator(dot)barone(at)gmail(dot)com
> wrote:

> I'm not stupid,
>

No one said you were. These lists see people of a wide range of skillsets
and expertise. In this case it might not be the answer for your issue, but
David's suggestion might help someone else having a similar problem in the
future.

> I added some columns before sending the query. I'm trying to write a query
> that returns the name and other information about the columns of a
> database. the query that is sent is the following
>
> select * from information_schema.columns col
> where col.table_schema!='pg_catalog'and
> col.table_schema!='information_schema'
>
> if i sent the query as "postgres", the result is a table that contain the
> the right column list. If I sent the query as "ssaa", the result is an
> empty table.
> I must to be able to retrieve the list of tables as a user "ssaa".
>

Logged in as ssaa, can you show the output of the following (in "psql"):

\dt+

and

show search_path;