Hi all, I created a database named "test" with the user "postgres" and I have given all privileges on database "test" to a user that I use daily, called "ssaa". By submitting, as user "ssaa", to "test" database the «select * from information_schema.columns with where col.table_schema! = 'Pg_catalog' and col.table_schema! = 'Information_schema'» query, instead of the list of columns, I have an empty table. I have to give some special permit ssaa user?
Your query as you've written it won't return what you expect. Try the following:
select * from information_schema.columns where table_schema not in ('information_schema','pg_catalog')