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

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) 18 בספטמבר,‏ 2020,‏ 12:13pm 3

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

נושא		תגובות	צפיות
Which table holds the post URL? Development	2	488	4 בפברואר,‏ 2021
Export all data of all posts Support	3	3926	20 בספטמבר,‏ 2021
Badge_posts in Data Explorer Data & reporting sql-query	1	314	14 בנובמבר,‏ 2022
Repairing damaged post_search_data (unable to create database dumps and execute search reindex) Self-hosting	11	2629	13 בפברואר,‏ 2017
Is there any way to extract a URL to a post from Discourse backend DB? Development	2	1070	25 בספטמבר,‏ 2019

איפה למצוא תוכן פוסטים במסד הנתונים

נושאים קשורים