5 ms·

Choosing between Postgres and MySQL is hard

• ttfkam 3y ago
  > MySQL is case-insensitive by default. Postgres is case-sensitive by default. Minor quibble: If you don't quote identifiers, they are case-insensitive in Postgres. (Case folding to lowercase by default, which ends up being a distinction without a difference.) SQL keywords are always case-sensitive. If you put double quotes around them though, the identifiers preserve case. SELECT * FROM "foo"; is the same as SELECT * FROM foo; is the same as SELECT * FROM Foo; But this next one will tell you it doesn't know which table you're talking about: SELECT * FROM "Foo"; Unless you made the table that way: CREATE TABLE "Foo" (); In which case only the last SELECT example will work.