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
11 months 23 days ago

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.

5 months 7 hours ago

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

4 months 18 days ago

You’ve got incredible info here