On Fri, Aug 23, 2013 at 8:12 AM, Salvatore Barone <salvator.bar...@gmail.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;