Postgresql – Add prefix to beginning of string in postgres
I have a table in a postgres database with data that looks like this: XX-001111111-11-Q011111o_ABC_90001u-0000101-9 The table has 1000 rows with similar looking strings. I want to update every row to add the 'AB-' prefix to it. So XX-001111111-11-Q011111o_ABC_90001u-0000101-9 would…