News for hackers. Stuff that matters.
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?
Re:Common mistakes in PostgreSQL by masklinn on Friday May 03, 2019 @10:24AM (#19818706)
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 );