postgresql - Why command dt gives - no relations found?

Question

I have created a database in postgres. It has 3 empty tables. The table has user tom as its Superuser along with root. I am logged in as tom and connected to mydb database. But still the commands d or dt - gives no relations found.

Is there any alternate to SHOW TABLE in postgresql?

Could not find solution here

I get results from - dt *.*.

question from:https://stackoverflow.com/questions/40865564/why-command-dt-gives-no-relations-found

Answer 1

It is not a problem with your search_path, it could be an issue with your schema permissions as described in the answer here. Check with dn+ that the public schema indicates permissions for the postgres role, and if not, grant them with: GRANT ALL ON SCHEMA public TO public;