PostgreSQL uses the C library's locale facilities for sorting strings:

• First, all the letters are compared, ignoring spaces and punctuation.
• It sorts upper and lower case letters together. So the order will be something like a A b B c C
• Then, spaces and punctuation are compared to break ties.

UI/UX Design by

We make sure that your target audience has the best possible experience with your digital product. You get:

• Design tailored to your audience
• Proven processes customized to your needs
• An expert team of experienced designers

Read more Show archive.org snapshot

Example:

PostgreSQL-FAQ: Why_do_my_strings_sort_incorrectly Show archive.org snapshot