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.