Postgres String Capitalization

Introduction The purpose here is to learn how best to use the various Postgres string capitalization functions to capitalize characters or change to lowercase. The functions we’ll explore here include Lower, Upper, Concat, Left, Right, Len, and Initcap. Prerequisites Beginner-level understanding of writing SQL with PostgreSQL or a similar relational database system such as Oracle, … Continued

Postgres String Case Lower and Upper in SQL

Introduction In this article, we will talk about the Postgres string case LOWER and UPPER in SQL to change characters from three perspectives, including: What? What do the LOWER and UPPER string functions do? How? How do we use these functions in our SQL scripts? Why? In what circumstances do we need these functions? Real … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.