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@xxxxxxxxxxx