There is already a default search path for a user. But it looks like you are trying to have a default search path per connection. I would be inclined to relegate that to cursor level where it more belongs: you can execute the set search_path=schema-name as soon as you have your cursor and it will persist until reset explicitly through the same cursor.