Peter Eisentraut wrote:
> Dave Page wrote:
>> No, it's the intended behaviour. pgAdmin doesn't have any idea how
>> you want to quote SET values, so it leaves it to you to add them.
>
> Just quote them all.
Doesn't work:
scratch=# set search_path = '"MyNameSpace1", "MyNameSpace2"';
ERROR: schema ""MyNameSpace1", "MyNameSpace2"" does not exist
That one must be unquoted:
scratch=# set search_path = "MyNameSpace1", "MyNameSpace2";
SET
Regards, Dave.