[数据库]USE “schema_name” in PostgreSQL
For those moving from MySQL to PostgreSQL, there are a few differences which you will need to get used to. One of these differences is the USE command, used to select the schema to select tables, views, etc from.
PostgreSQL does not have the USE command. Instead, you can use:
SET search_path TO [schema_name]
For example, if we have a schema mySchema in which we are querying the person table, instead of
SELECT * FROM mySchema.person, we can simply type
SET search_path TO mySchema and use
SELECT * FROM person for all subsequent queries. mySchema will remain the default schema until the next SET command is issued, or the connection is closed.