postgres concat_ws 1

postgres concat_ws

CONCAT_WS(separator, str_1, str_2, ...) as some_name

Here is what the above code is Doing:
1. We’re using the CONCAT_WS function to concatenate the values in the first_name and last_name columns.
2. We’re using the AS keyword to rename the column to full_name.
3. We’re using the comma (,) to separate the columns we want to concatenate.
4. We’re using the single quote (‘) to specify the separator we want to use between the values.

Similar Posts