79650686

Date: 2025-06-03 06:01:50
Score: 2
Natty:
Report link

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.

Reasons:
  • No code block (0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: Simon Clinch