Set Default Schema / search path (PostgreSQL)

From ben.goodacre.name/tech

Jump to: navigation, search

When schema names are omitted the default public schema is searched first, followed by the a schema entitled by the current username. If you would like to use another default schema it can be changed as follows:

SET search_path TO new_schema, public;
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox