1

I have a postgres 9.4 database and when I use the:

\dt

command, tables in the 'public' schema, and other user-created schemas are shown.

I have the exact same database on a Postgres 9.6 server and when I use:

\dt

only the tables in the 'public' schema are shown, and in order to see tables in the other user-created schema, i have to use:

\dt schemaname.*

to see those tables. Is this a difference between 9.4 and 9.6, or any i missing something else. permissions?

Improve this question

1 Answer 1

Reset to default
3

Check the search_path for each user you're trying to check on.

SHOW search_path;

If they're different you can set them with SET search_path TO mySchema, public;

Improve this answer
2
  • this is what i needed. incidentally, my real problem appeared to be the fact that i had capital letters and an unserscore '_' in my schema name, and that was throwing a wrench into the works. Commented Sep 11, 2017 at 17:44
  • Yeah the whole folding to lower (or upper) case thing in SQL bites a lot of folks int he butt. Glad you got it sussed. Commented Sep 11, 2017 at 19:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.