Ugh, that second link. It scratches at the right place, but the conclusion is wildly wrong.

This Stackoverflow answer explains it better: https://stackoverflow.com/questions/21796446/postgres-case-sensitivity

But it's best to rely on the official documentation: https://www.postgresql.org/docs/16/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS