1. Learn
    2. /
  2. Courses
    3. /
  3. Functions for Manipulating Data in PostgreSQL

Exercise

Concatenating strings

In this exercise and the ones that follow, we are going to derive new fields from columns within the customer and film tables of the DVD rental database.

We'll start with the customer table and create a query to return the customers name and email address formatted such that we could use it as a "To" field in an email script or program. This format will look like the following:

Brian Piccolo <[email protected]>

In the first step of the exercise, use the || operator to do the string concatenation and in the second step, use the CONCAT() functions.

Instructions 1/2

undefined XP
  • 1
    • Concatenate the first_name and last_name columns separated by a single space followed by email surrounded by < and >.
  • 2
    • Now use the CONCAT() function to do the same operation as the previous step.