I've found this with google, but it doesn't seem to work. How can I append data without rewriting the existing data?
Let the table1 contains two fields id and value. U need to append some text
to the existing values. is it ?
ok...use the following postgresql query .
update table1 set values = values || 'newtext' where id = 1
|| ------> string concat operator
This will result in
No I understand, in the example I did find on the internet I got confused with the "values" column, I thought that " = values || " meant: "append to the values present". Now I've changed to:
update my_table set my_column = my_column || 'my_append' where my_table_id = 8;