すべての会話をファイルと構造化データにダンプする

[pfaffman (Jay Pfaffman)]

SELECT * FROM posts WHERE topic_id=425

これで、クエリ内の最初のトピックの投稿が取得できます（スマホで入力しているため、正確な構文かどうかは保証できません）。

ただし、JSON が欲しい場合は、以下のような方法も考えられます。

Dump all conversations in a file and structured data

This question is similar to this one: Does Discourse support export conversations as an organized bulk of data? but we are looking for a way to do some NLP on all conversations of our Discourse site. Someone in our team asked if this could be done by acting at some low-level, in the backend, e.g. exporting the database but without the table, with something like pg_dump --schema-only. I didn’t fully understand what my colleague meant but I thought maybe you would.