set default schema for user: postgres

 
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;

Leave a Reply

Your email address will not be published.