' and \ characters in passwords - Mailing list pgsql-general

From Andrus Moor
Subject ' and \ characters in passwords
Date
Msg-id dvhul6$3qe$1@news.hub.org
Whole thread Raw
Responses Re: ' and \ characters in passwords  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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.



pgsql-general by date:

Previous
From: "Hrishikesh Deshmukh"
Date:
Subject: Re: OpenSuse10.0 and postgresql
Next
From: Chris Travers
Date:
Subject: Re: Clustered PostgreSQL