How do I access a table within a schema without having to use the schema prefix (Postgres + PHP)?

Question

I have some tables created under a schema. At the moment, I can access the table within the schema using:

select * from myschema.mytable

I am searching for ways to avoid using the schema name. something like:

select * from mytable

But I'm not finding the answers.

Can you help? Thanks

Answer 1

Schema search path would work for this:

To see the current value:

SHOW search_path;

To change the value (append new schema):

SET search_path TO myschema,public;

It is documented here, in section 5.7.3