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.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
