# Database export \[Mar 26\]

**URL:** <https://community.nocodb.com/t/database-export-mar-26/270>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 8:16am UTC](https://community.nocodb.com/t/database-export-mar-26/270 "2022-11-03T08:16:24Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:16am UTC](https://community.nocodb.com/t/database-export-mar-26/270/1 "2022-11-03T08:16:24Z")

</div>

> 🙋‍♂️ **bakrx** _asked_

## Hello!

#### I used 1 click heroku deploy and created a simple database. Now I want to export it as a database file but I didn’t find any such option (only found an option to export as .csv, and another option to export metadata). Is there a way to export as a database?

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:16am UTC](https://community.nocodb.com/t/database-export-mar-26/270/2 "2022-11-03T08:16:25Z")

</div>

> 💁 **o1lab** _replied_

#### the underlying db is postgres - you can simply connect to it by using postgres db credentials. Tool like pgdump can be used to dump the data. Since DB can house millions of records - exporting the data is beyond teh scope of this project

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:16am UTC](https://community.nocodb.com/t/database-export-mar-26/270/3 "2022-11-03T08:16:27Z")

</div>

> 🙋‍♂️ **bakrx** _replied_

#### Oh, I didn’t know nocodb uses postgres. Thanks for the info!

#### 

#### Could you please tell me where/how should I use the tools you mentioned?

#### 

#### P.S. I’m not a programmer and I’m only using nocodb for small personal stuff as a cross-platform replacement for excel/google sheets (as I need some relational capabilities which are hard to do in sheets).

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:16am UTC](https://community.nocodb.com/t/database-export-mar-26/270/4 "2022-11-03T08:16:28Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### To be exact, one-click heroku deploy takes an add-on which is Heroku Postgres. The connection string can be found -

#### 

#### Go to Heroku \> Choose your app \> Settings \> Config Vars \> Click ‘Reveal Config Vars’ \> DATABASE\_URL

#### 

#### You should see the value like `postgres://<USERNAME>:<PASSWORD>@<HOST>:5432/<DATABASE>`

#### 

#### As you said you arent a programmer, I’d suggest you to use a GUI, let’s say DBeaver to dump the database. For the steps to export, please check out its official doc - [https://dbeaver.com/docs/wiki/Backup-Restore/](https://dbeaver.com/docs/wiki/Backup-Restore/)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:16am UTC](https://community.nocodb.com/t/database-export-mar-26/270/5 "2022-11-03T08:16:29Z")

</div>

> 🙋‍♂️ **bakrx** _replied_

#### Thanks for the detailed info!

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:16am UTC](https://community.nocodb.com/t/database-export-mar-26/270/6 "2022-11-03T08:16:30Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/956296724962508861)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)
