SHOW search_path;
will return "$user",public
-- To change search_path on a connection-level
SET search_path TO your_schmea;
-- To change search_path on a database-level
ALTER database "your_database" SET search_path TO your_schmea;
Live Your Passion
SHOW search_path;
will return "$user",public
-- To change search_path on a connection-level
SET search_path TO your_schmea;
-- To change search_path on a database-level
ALTER database "your_database" SET search_path TO your_schmea;