Embed Notice

my adapted query for the "user" table

update "user" set "sharedInbox" = 'https://' || split_part("inbox", '/', 3) || "sharedInbox" where "sharedInbox" = '/inbox';

don't have a general one for the "following" table tho. this is the select i used to check which fields needs changing

select "following"."followerSharedInbox", "following"."followerId", "user"."username", "user"."inbox" from "following" inner join "user" on "following"."followerId" = "user"."id" WHERE "followerSharedInbox" = '/inbox' OR "followeeSharedInbox" = '/inbox';

(yes, i know. i'm a messy query writer)