Re: Error in pgaccess (parse error at or near """) on create new user with password - Mailing list pgsql-bugs

Peter Eisentraut <e99re41@DoCS.UU.SE> writes:
> On Tue, 9 May 2000, Thomas Swan wrote:
>> CREATE user "whomever" WITH PASSWORD "foo" CREATEDB CREATEUSER
>>
>> ERROR: parser: parse error at or near """

> The password must be single-quoted nowadays. Put that on the 7.0.1 list

I'd say single quotes is correct behavior for the password, actually.
Double quotes are only appropriate in a position where an SQL name is
wanted.  The underlying syntax is really
    CREATE USER <name> WITH PASSWORD <string>

            regards, tom lane