Wednesday, February 04, 2015

Article: Don't use double quotes in PostgreSQL

Another good "why x is bad" article...I hate to overgeneralize, but it's simply true. This is one of those features that could maybe-kinda-sorta hypothetically be a good thing on rare occasion, but I've never seen those occasions.

I added this comment in reply:
Absolutely agreed. Oracle works similarly - when I first used the Oracle Enterprise Manager GUI tool about 11 years ago [correction: actually 12 - what year is it?? :)], I discovered it would, like PGAdmin, add double quotes as a courtesy for you. I could see this tripping up newbies while providing few benefits. They should teach this as fundamental wisdom in school: junk food is bad, drug abuse is bad, quotes in identifiers are bad.

No comments: