Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in PostgreSQL

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.