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. +