Peter Eisentraut <[EMAIL PROTECTED]> 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
