' and \ characters in passwords

From: "Andrus Moor" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: ' and \ characters in passwords
Date: 2006-03-18 21:32:54
Message-ID: dvhul6$3qe$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hrishikesh Deshmukh 2006-03-18 21:38:13 Re: OpenSuse10.0 and postgresql
Previous Message Adrian Klaver 2006-03-18 21:05:33 Re: OpenSuse10.0 and postgresql