PostgreSQL: Why identifiers are Case-Sensitive

Guys, this is one of the important discussion of PostgreSQL.
All identifiers, including column name are Case-Sensitive or not.

Yes: when you use double-quoted, it is Case-Sensitive.
No: when you do not use double-quoted, it is not Case-Sensitive.

For example:
With double-quoted:

Without double-quoted:

My advice is to never use double-quoted for any identifiers otherwise you will face problem of case-sensitive.
When you do not use double-quoted, PostgreSQL internally store all identifiers in small latter and you can access this all identifiers in any case.

When you create your table using PGAdmin UI, by default it creates all identifiers with double-quoted.
Always try to create your database objects using a SQL script.

Anvesh Patel

Leave a Reply

3 Comments on "PostgreSQL: Why identifiers are Case-Sensitive"

Notify of
avatar
Sort by:   newest | oldest | most voted
navigate to these guys
Guest
navigate to these guys

I just want to mention I am beginner to blogs and definitely liked this page. Likely I’m planning to bookmark your website . You absolutely have superb stories. Thank you for sharing with us your web-site.

csgo
Guest

Unbelievably individual friendly site. Astounding details offered on couple of clicks

nba2k
Guest

You’ve got incredible info here

wpDiscuz