Comment by mannyv

The reason you don’t this in psql is that for some versions of Postgres case is significant and you need to use quotation marks. I ran into this at one point and it drove me bonkers.

Older versions of pg let you create cases identifiers without quotes. I don’t care enough to look which ones.

https://sqlpey.com/sql/postgresql-identifier-case-sensitivit...