I backed up the database (postgresql) and turn them into csv to see it has losses. I cannot find the post table. What’s the name for this table? Thank you.

[图片] sharkdeng: What’s the name for this table? Thank you. name of the table is posts

If you don’t already know it, Data Explorer Plugin may be of interest.

Thanks. I got that table, but it is empty to make me suspect posts are stored in an another table. I checked other tables such as users, categories. All are normal except the posts table.

如何在数据库中查找帖子内容

支持

Canapin (Coin-coin le Canapin) 2020 年9 月 18 日 12:13 3

如果您还不了解，Discourse Data Explorer 可能会对您有所帮助。

4 个赞

话题		回复	浏览量
Which table holds the post URL? Development	2	476	2021 年2 月 4 日
Export all data of all posts Support	3	3876	2021 年9 月 20 日
Badge_posts in Data Explorer Data & reporting sql-query	1	299	2022 年11 月 14 日
Repairing damaged post_search_data (unable to create database dumps and execute search reindex) Self-hosting	13	2600	2019 年5 月 2 日
Is there any way to extract a URL to a post from Discourse backend DB? Development	2	1052	2019 年9 月 25 日

如何在数据库中查找帖子内容

相关话题