PostgreSQL: Why identifiers are Case-Sensitive

Guys, this is one of the important discussion of PostgreSQL. All identifiers, including column name, are Case-Sensitive in PostgreSQL? Yes: when you define identifier in the double-quote, it is a Case-Sensitive. No: when you do not use double-quote for an identifier, it is not a Case-Sensitive. For example: With double-quoted: [crayon-6791a77b8d4c1746406238/] Without double-quoted: [crayon-6791a77b8d4cb617256644/] My … Continue reading PostgreSQL: Why identifiers are Case-Sensitive