When is the schema name "public" required?

Question

PostgreSQL

I had code in which queries were executed without specifying the public schema, i.e. were simple:
SELECT * FROM tableName

Deployed a very similar configuration on a working Postgres 13.2 server, copied the query into the SQL manager and he cursed. that cannot fulfill it. schema is not specified. At the same time, apparently, requests from the code itself are executed. nothing falls.

"11:25:47 Kernel error: ERROR: relation 'tableName' does not exist." At the same time, the documentation says: "public is defined as the default schema name when no schema name is specified"

How can this be? Does the driver have an effect?

Answer 1

There is such a thing, search_path . Perhaps it was set up in the old place.