Use ' schema_name ' in PostgreSQL

http://timmurphy.org/tag/mysql/

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

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

For those moving from MySQL to PostgreSQL, there is a few differences which you'll 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 has the use command. Instead, can use:

SET search_path TO [schema_name]

For example, if we had a schema MySchema in which we is querying the person table, instead SELECT * FROM mySchema.person of, W  E can simply type and use for all SET search_path TO mySchema SELECT * FROM person subsequent queries. MySchema would remain the default schema until the next SET command is issued, or the connection is closed.

Use ' schema_name ' in PostgreSQL