# PostgreSQL

**URL:** https://forum.ficusonline.com/t/topic/507
**Category:** Server
**Created:** [2024 年 2 月 8 日午前 4:29 UTC](https://forum.ficusonline.com/t/topic/507 "2024-02-08T04:29:42Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![tk-fuse](https://forum.ficusonline.com/user_avatar/forum.ficusonline.com/tk-fuse/32/255_2.png) [@tk-fuse](https://forum.ficusonline.com/u/tk-fuse)
#### Post date: [2024 年 3 月 31 日午前 7:41 UTC](https://forum.ficusonline.com/t/topic/507/2 "2024-03-31T07:41:11Z")

</div>

## pgAdmin クエリ実行

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

 ![Screenshot from 2024-03-31 16-30-32](https://forum.ficusonline.com/uploads/default/original/2X/1/10596d4d12e1a7d1dec88843bc53b3fd663cb6f3.png)

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

```

---

_[View the full topic](https://forum.ficusonline.com/t/topic/507)._