Photo by @damianpatkowski on Unsplash

Lower case postgres table names

01 May, 2021

In Postgres, unquoted column names are internally lower cased.

Therefore, create all tables as with lower_cased column names.

Or else, psql suggestions is broken, and unquoted column selections break things somewhere, but not necessarily in your tool if you configed things your way.

So don't cling to your language-specific way of doing casing. Postgres columns are Postgres columns – not Javascript columns.

Video of autocomplete struggling