Autumn Offers - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
1. Introduction
Concatenation
Simple text functions
Modifying strings
Summary

Instruction

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!

Exercise

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

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