• 0 Posts
  • 3 Comments
Joined 11 months ago
cake
Cake day: August 16th, 2023

help-circle



  • Postgres normalizes table and field names to lowercase, unless you put them in quotes. It’s also case sensitive.

    That means if you use quotes and capital letters when creating the table, then it’s impossible to refer to that table without using quotes.

    It also means if you rename the table later to be all lowercase, then all your existing code will break.

    Still a much better database than MySQL though.