Hi
Use update statement .
eg.
table1 (tablename)
id values
1 text1
2 text2
3 text3
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
table1
id values
1 text1newtext
2 text2
3 text3
If you want to update all the rows remove the 'where' condition
Try this and reply
-somaskarthic
I am a novice when it comes to using SQL. I would like to append text to existing data in a specified column, but I can not figure out how to do it. I was trying to use an update query, but as far as I can tell this only replaces the data within the column. Any help would be appreciated