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, Discourse Data Explorer 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) 9월 18, 2020, 12:13오후 3

아직 모르셨다면, Discourse Data Explorer 링크가 도움이 될 수 있습니다.

글		댓글	조회수
Which table holds the post URL? Development	2	550	2월 4, 2021
Export all data of all posts Product Support	3	4038	9월 20, 2021
Badge_posts in Data Explorer Data & reporting sql-query	1	348	11월 14, 2022
Repairing damaged post_search_data (unable to create database dumps and execute search reindex) Self-hosting	11	2716	2월 13, 2017
Is there any way to extract a URL to a post from Discourse backend DB? Development	2	1114	9월 25, 2019

데이터베이스에서 게시글 내용을 찾는 방법

Related topics