From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: =?UTF-8?B?5q+b5q+b?= <krave@163.com>, pgsql-general@lists.postgresql.org
Subject: Re: How to use createdb command with newly created user?
In-reply-to: <CAKFQuwb-Kp4dnE+EM2WCeJ8tuai-Lx_Ja2Gb8mEOkNRe9h8Vww@mail.gmail.com>
References: <540f69f.2ec4.1904668b6c4.Coremail.krave@163.com> <CAKFQuwb-Kp4dnE+EM2WCeJ8tuai-Lx_Ja2Gb8mEOkNRe9h8Vww@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Sun, 23 Jun 2024 11:47:44 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <987118.1719169237.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Sun, 23 Jun 2024 15:00:37 -0400
Message-ID: <987119.1719169237@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/987119.1719169237%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Sun, Jun 23, 2024, 11:43 毛毛 <krave@163.com> wrote:
>> Then I run the following command on PowerShell on Windows 10:
>> createdb -U Baba -W test_db
>> But no mater how I tried, the password always failed.

> You named the user "baba" all lower-case but your createdb command uses
> Baba and in the OS the case-folding of identifiers does not happen.  Baba
> != baba  is your issue.

FWIW, I think using -W in interactive commands is a bad habit
that you should drop.  Because it forces a password prompt, it
easily confuses people into thinking that their problem is
password-related whether it actually is or not.

(I notice that with createdb, it actually seems to force *two*
password prompts when there is something wrong.  That's unlike
what happens with psql; maybe we should try to improve that.
But on the other hand, it's hard to get excited about putting
work into improving a behavior that we deprecate using at all.)

			regards, tom lane