Any way to dump the data of the supabase postgres ...
# off-topicl
Link
02/20/2022, 5:42 PMAny way to dump the data of the supabase postgres database
k
ktosiek
02/20/2022, 5:49 PMLet's continue in a thread. If you can't use WSL for some reason (old or Server Windows), you should still be able to use pgAdmin.
ktosiek
02/20/2022, 5:50 PMDo you have some favourite tool for interacting with PostgreSQL? It should have an option to dump the DB
l
Link
02/20/2022, 5:53 PMWell no
Link
02/20/2022, 5:53 PMI only ever used the supabase dashboard
k
ktosiek
02/20/2022, 5:56 PMDataGrip (from JetBrains, has free trial) or pgAdmin (PostgreSQL license, I think) should work, and they are GUI tools.
l
Link
02/20/2022, 5:57 PMNever used any of these before
Link
02/20/2022, 5:58 PMbut I could use datagrip ig
Link
02/20/2022, 5:59 PMDo they also allow me to import the exported data to another database?
n
Neucoas
02/20/2022, 6:15 PMWhen you export or dump the data you are basically creating a huge sql file
Neucoas
02/20/2022, 6:15 PMSo any tool that can run sql will be able to import your dump
k
ktosiek
02/20/2022, 6:20 PMas Neucoas said, it should be simple.
Just make sure you don't change the format - the default raw SQL format is not very efficient, but it's simple to work with (and with DBs in hundreds of megabytes, it's good enough)
l
Link
02/20/2022, 6:34 PMBut do you know any
Link
02/20/2022, 6:34 PMDo you know any tools that I can use to import the data from the sql file
n
Neucoas
02/20/2022, 7:10 PMWhich platform? Windows? Mac?
Neucoas
02/20/2022, 7:10 PMFor windows HeidiSQL is a good one
Neucoas
02/20/2022, 7:10 PMFor mac I like tablePlus
l
Link
02/20/2022, 7:48 PMWindows
Link
02/20/2022, 8:02 PM@Neucoas @ktosiek Btw I appreciate the help you both gave me a lot and im very thankful for it
Link
02/20/2022, 8:02 PM👍