I found that \ characters needs not to be quoted in password strings create role test1 password '\' is OK. I havent found any mention of this behaviour in docs. Where this is documented ? I created role create role test2 password '''' Trying to login using password ' causes error from my ODBC client: Connectivity error: FATAL: password authentication failed for user "test2" ODBC and postgres logs do not show anything about this issue. How can I find which is wrong ? Is create role test2 password '''' legal way to set password to ' character ? Andrus.
