skip to content
Notes && Anecdotes
Photo by @damianpatkowski on UnsplashPhoto by @damianpatkowski on Unsplash

Please lower case db table names

postgres

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