postgres add value to an existing column

Question

I have a table like this for example:

id, first_name, last_name
1, James, Anderson
2, William, Davis
3, Ethan, Walsh

I would like to add a prefix to their first names,
So it will looks like this:

id, first_name, last_name
1, EXT-James, Anderson
2, EXT-William, Davis
3, EXT-Ethan, Walsh

So basically I want to add the value 'EXT-' to the first_name column
Is there any way to do it ?

user330315 · Accepted Answer · 2014-10-20 18:34:03Z

3

update the_table
  set first_name = 'EXT-'||first_name;

answered Oct 20, 2014 at 18:34

user330315

Sign up to request clarification or add additional context in comments.

Comments

Steve · Accepted Answer · 2014-10-20 18:35:27Z

0

SELECT 'EXT-' || first_name FROM YourTable

answered Oct 20, 2014 at 18:35

Steve

5,5553 gold badges20 silver badges32 bronze badges