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 an

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-sensitivity/ https://sqlpey.com/sql/postgresql-identifier-case-sensitivit...