Re:Common mistakes in PostgreSQL
by irrational on Friday May 03, 2019 @10:18AM
(#19818646)
It works the same way in Oracle - i.e., it is case-insensitive. What RDS are case-sensitive in terms of things like table/column names?
[ Parent
| on HN ]
The case-insensitive identifiers is SQL-standard. I think their issue is that pg lowercases identifiers before creation / storage. That is
create table Foo ( Bar serial );
is equivalent to create table "foo" ( "bar" serial );
not create table "Foo" ( "Bar" serial );