# Export all data of all posts

**URL:** <https://meta.discourse.org/t/export-all-data-of-all-posts/152823>\
**Category:** Support\
**Created:** [May 26, 2020, 8:19pm UTC](https://meta.discourse.org/t/export-all-data-of-all-posts/152823 "2020-05-26T20:19:07Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![jhuynh](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jhuynh/32/216697_2.png) [@jhuynh](https://meta.discourse.org/u/jhuynh)\
**Post date:** [September 20, 2021, 7:55pm UTC](https://meta.discourse.org/t/export-all-data-of-all-posts/152823/8 "2021-09-20T19:55:54Z")

</div>

I tried this but when I try to run the .sql file in on my PostgreSQL database, I get a syntax error:

```plaintext
ERROR: syntax error at or near "1"
LINE 5066: 1 33a64b9c942fe3f0b264467590ac83a2207b557db26e86ec8d3ebcf605...
           ^
SQL state: 42601
Character: 126056

```

Any advice?

---

_[View the full topic](https://meta.discourse.org/t/export-all-data-of-all-posts/152823)._