Hi! I am launching my Supabase powered app to production, for that I need to create a clean copy of my public schema. I can not seem to be able to run pg_dump on the dashboard sql editor. has anyone done this before? any other suggestions on how to have two Supabase projects, one for development and one for production are welcome! Thanks

Hello @Zozo! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Hi You can't use the ``pg_dump`` in the sql editor indeed, but you can use it on your side in any terminal you have. The connection URI is available in settings @Zozo

Zozo (2022-05-09)

Here is the command i'm using to backup my Supabase database

pg_dump -d "<your connection string>" > backup.sql

thank you! @Olyno I managed to backup through pgAdmin.