Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
1. Introduction
Simple text functions
Modifying strings


In this part, we'll teach you some basic PostgreSQL string functions. They'll help you manipulate text values in your queries, and you'll learn how to:

  • Concatenate (combine) multiple text values into one.
  • Convert text to uppercase and lowercase.
  • Convert text to display characters in reverse order.
  • Select substrings and find their position in a string.
  • Find the length of a string.
  • Trim a string.
  • Replace parts of a string.

We'll work with data from a marketing agency. Let's go!


Select all data from the item table. It contains the following columns:

  • id – item identifiers.
  • name – their names.
  • type – their descriptions.