Re: ' 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. +