Should I always be prefixing the schema name before the table names in queries(PostgreSQL 14)?

Question

I am running Postgres 14 on my Mac. I installed the app version. I am trying from both the psql window and through jdbc calls and it expects the schema name to be prefixed always.

Example: select * from public."Melting";

Thanks.

Answer 1

That's a good habit. Always use the explicit schema names, then you don't have to rely on the current setting of search_path.