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