' and \ characters in passwords

Andrus Moor wrote:

I found that \ characters needs not to be quoted in password strings

create role test1 password '\'

is OK.

Not sure what client you are using but in psql this fails to find the
ending quote, as it should.

---------------------------------------------------------------------------

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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

--
Bruce Momjian http://candle.pha.pa.us
SRA OSS, Inc. http://www.sraoss.com

+ If your life is a hard drive, Christ can be your backup. +