Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sLbCY-00FaKc-5l
	for pgsql-general@arkaria.postgresql.org; Mon, 24 Jun 2024 04:21:10 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sLbCW-004UvK-1M
	for pgsql-general@arkaria.postgresql.org; Mon, 24 Jun 2024 04:21:08 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sLbCU-004UZV-Ga
	for pgsql-general@lists.postgresql.org; Mon, 24 Jun 2024 04:21:07 +0000
Received: from wfout2-smtp.messagingengine.com ([64.147.123.145])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1sLbCP-002pMT-3b
	for pgsql-general@lists.postgresql.org; Mon, 24 Jun 2024 04:21:05 +0000
Received: from compute4.internal (compute4.nyi.internal [10.202.2.44])
	by mailfout.west.internal (Postfix) with ESMTP id 0E5F41C00092;
	Mon, 24 Jun 2024 00:20:58 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute4.internal (MEProxy); Mon, 24 Jun 2024 00:20:59 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:content-transfer-encoding:content-type:content-type:date:date
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm1; t=1719202858;
	 x=1719289258; bh=pDBo4EvjuwBPoYKOcGKSvu02aVS1rJxhFWLjMBJdDPU=; b=
	LpcFg+gJQqCXvMktoOIM1fxiw/Fsi6xdp92fqAOWsMiKX6zhhN10mfb/kx/hZ2Yj
	UdPktMvvNE5ojii1Fpu2ij1AhxE+Z/z12EianvJSpdhhXGErOvxy8vzuJGmEy5mu
	FK8fER6vmoblMnmvuMt5JlmNTqJlEb5fi18pcbVv4ajBCcBdqLWohGVuyY+NAWDg
	gW0US1WKUHluBJmfv3DdgqgB7hxv2svOU6JyxISmUA9z+mgiXKoYwxSrdiQUUZYG
	Xhwyb2I+xEG5wVSxH+ZwiXTTKXmt0+kYxF9/be6Q13DkTA3qH5JvwkMk55//X8h+
	ni95MeaaKtGkUd+//SnF4A==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy
	:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1719202858; x=
	1719289258; bh=pDBo4EvjuwBPoYKOcGKSvu02aVS1rJxhFWLjMBJdDPU=; b=u
	c5oDr2VZ1xkVijDYVSbw5Mis9pGYwyspjCJ9fsXNoy+l9sP4hk4p208QocCqq2Ge
	w0s/F1/sc48g1Lau+dfNReqo0fcq0gMyybbsJyi0DgGMY/di1oN9LQ2zLJnJjuQX
	4Y1F+nbUoioW6/aLL+9fx81/s4ZAwB62luqnbaFntGvUHfiv1YgBuflD1mKKtpiY
	Wsij6Tua/cFhtqtJRB6ywdkJuXyNqXvAVCCG/ZHs+g6Xs1L6YM+V2liTgxw+Ncg8
	CZH+xUNIU2T78+f5EIUhMbo496LYS5+38XA+TDkkeVYHHiTSC2HmYeMQLFc0fUvX
	OyItP77d8wpbo3RNDR8Mw==
X-ME-Sender: <xms:KvR4ZpWpIGa1ychNC7OfhmxPazJhSl9YikK6pKbuaeYucYHviFhV-g>
    <xme:KvR4ZpkulqcnxIEkE5jY5AgusBFvl3WsS_tEDsu24164xXb6wMWFGC_3whZPM2fHn
    rCWLD4vti4mtkQ>
X-ME-Received: <xmr:KvR4ZlalO-O9v4fND5CAAksd-ZqseGM5RQOZydkBu9bPX-iyq7KfeEHd3HsqSwVITpkE6ZtruTxP7mQUMFGOliomKo4>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrfeegtddgkeefucetufdoteggodetrfdotf
    fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen
    uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne
    cujfgurhepkfffgggfuffvfhfhjggtgfesthekredttddvjeenucfhrhhomheptegurhhi
    rghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtoh
    hmqeenucggtffrrghtthgvrhhnpeelgeevkeekkeeuiefgtdevieeluefhfedufeetkeej
    ffekjeeujeehgeehgeektdenucffohhmrghinhepphhoshhtghhrvghsqhhlrdhorhhgne
    cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhi
    rghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomh
X-ME-Proxy: <xmx:KvR4ZsUVHJuKBtqlu7KytarCEX52JZsHkKckcWN6F2ixy4LzlhespQ>
    <xmx:KvR4ZjkHZGqvgEP-pWody5lcVLwi1zRCfymIsNY52mmjTiZlF8hnIQ>
    <xmx:KvR4ZpflhsI-Hjm-3bhoMVH7bq0qXlk-6ZI5z3mMtUgraWs9mcbfsw>
    <xmx:KvR4ZtH8hhHospx2Bam5vXAEdZ2KDTQus6qngOaBPiAjLLDSByrWZw>
    <xmx:KvR4ZoxiaQbtfFcLc4LLO6IEu7jkL_Rpf6ELAeYleG9f6va7NAfH8nDh>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon,
 24 Jun 2024 00:20:58 -0400 (EDT)
Message-ID: <664baf0e-8d7d-44a3-8eb8-f9676eeae39d@aklaver.com>
Date: Sun, 23 Jun 2024 21:20:57 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: How to use createdb command with newly created user?
To: =?UTF-8?B?5q+b5q+b?= <krave@163.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <540f69f.2ec4.1904668b6c4.Coremail.krave@163.com>
 <CAKFQuwb-Kp4dnE+EM2WCeJ8tuai-Lx_Ja2Gb8mEOkNRe9h8Vww@mail.gmail.com>
 <6697c935.2f13.190468ca053.Coremail.krave@163.com>
 <CANzqJaCkH5BqXKi8zB8QCSbxBrv8W=GNf-HfADg4thm2V9zqTw@mail.gmail.com>
 <5231216.46bb.19048511cac.Coremail.krave@163.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <5231216.46bb.19048511cac.Coremail.krave@163.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/664baf0e-8d7d-44a3-8eb8-f9676eeae39d%40aklaver.com>
Precedence: bulk

On 6/23/24 20:36, 毛毛 wrote:
> 
> 
> Thank you for your advice.
> 
> .pgpass file would help a lot.
> 
> 
> I recently started to writing SQL on PostgreSQL.
> 
> I think I should use capitial letters as sparingly as possible for 
> identifiers.

Take a look at:

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

It will answer a lot of questions.


-- 
Adrian Klaver
adrian.klaver@aklaver.com