How to export or import a database in the program DataGrip…
I have already described how to export to PhpStorm earlier. Here I will describe the export and import in the DataGrip program in more detail.
Select tables to export
Click in the context menu Export with ‘pg_dump’
Change format to tar archive and run run
We choose public (structure in PostgreSQL)
Push Restore with ‘pg_restore’
Then click Run