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