ALTER DATABASE dbname SET search_path=new_search_path;You can also modify a specific user’s search path with ALTER USER.
Others recommend setting the search_path in the postgresql.conf. Current versions of PostgreSQL can set the search_path permanently on a per-database basis without having to touch system configuration files:


