Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

14
  • 6
    @ArtB: The SQL standard defines case insensitive identifiers, just like Postgres implements it. The only deviation: unquoted identifiers are folded to upper case in the standard, but pg lower-cases everything that isn't double-quoted. (Only relevant in rare corner cases.) Details in the manual here. Commented Oct 29, 2014 at 15:17
  • 1
    @adfs: I don't think I can explain it any better than I already did. For more, follow the link to the manual I provided repeatedly. Commented Nov 8, 2014 at 14:09
  • 31
    @adfs: In SQL, foobar, FOOBAR and FooBar are the same identifier. However "foobar", "FooBar" and "FOOBAR" are different identifiers Commented Apr 5, 2015 at 21:23
  • 8
    @a_horse_with_no_name yes, but under SQL foobar and FOOBAR are the same as "FOOBAR", under potgresql FOOBAR and foobar etc are the same as "foobar". Commented Mar 14, 2016 at 1:55
  • 2
    @KamelMili: I suggest to ask your question as question, providing all necessary information. Comments are not the place. You can always link to this answer for context. And you can leave a comment with the link to your related question here (to also get my attention). Commented Mar 25, 2016 at 13:43