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.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

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

Notify of
Sort by:   newest | oldest | most voted
navigate to these guys
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.


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


You’ve got incredible info here