How to Append Text in PostgreSQL

Used CoPilot, then verified that it was correct. In PostgreSQL, you can append text to a string using the concatenation operator ||.

Example:

1

SELECT 'Hello' || ' ' || 'World' AS result;

This will return:

 result  
---------
 Hello World

Appending to a column value:

If you want to append text to a value in a column, you can do something like:

1
2
3

UPDATE your_table
SET your_column = your_column || ' appended text'
WHERE some_condition;

Let me know if you want to append conditionally, or based on values from another column!

I did the following:

1
2
3
4

raw_test_data> update sql_reports.emails
                  set emails = emails || ';person@example.com'
                     ,comment = 'Added person to the group.' 
                where name in ('group1','group2','group3');   

This enabled me to add this person’s email address to multiple email groups.