PostgreSQL

Linux Server
2

pgAdmin クエリ実行

テーブルposts.translationsのcontent内のurlを置換え

Screenshot from 2024-03-31 16-30-32
Screenshot from 2024-03-31 16-30-321295×836 95.7 KB

UPDATE public.posts_translations
SET content = REPLACE(content, 'http://localhost:8055', 'https://api.ficusonline.com')
WHERE content LIKE '%http://localhost:8055%';