USE "schema_name" in PostgreSQL, PostgreSQL Schema

USE "schema_name" in PostgreSQL, PostgreSQL Schema

Http://timmurphy.org/tag/mysql/

Http://timmurphy.org/2009/11/17/use-schema_name-in-postgresql/

==========================================

For those moving from MySQL to PostgreSQL, there are a few differences which you will need to get used. 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 schemaMySchemaIn which we are queryingPersonTable, insteadSELECT * FROM mySchema.person, We can simply typeSET search_path TO mySchemaAnd useSELECT * FROM personFor all subsequent queries.MySchemaWill remain the default schema until the next SET command is issued, or the connection is closed.