postgrsql update， 给指定字段批量加前缀

使用||连接

update user_accounts set principal = ('2022-09-06-' || principal) where user_id NOT IN (select id from users) ;