How to Export and Import PostgreSQL using DBeaver

Nowadays, GUIs (Graphical User Interface) for database management are required for several important reasons, mainly related to ease of use, efficiency, and productivity in work. There are several popular GUIs including: DBeaver, HeidiSQL, phpMyAdmin, Navicat, and DataGrip. On this occasion, we will discuss how to export and import using one of the GUIs mentioned above, namely with DBeaver. 

The first step of course we have to install the DBeaver first, if so please follow the steps below: 

Export Database

Select the database to be exported then right-click the Tools -> Execute Script menu.

Next, select and customize the objects and tables that will be exported. Then click Next.

Select the database storage folder location and fill in the file name pattern according to the database name you want. Then click Start.

Wait for the backup process to complete like this and the database is successfully exported.

Import Database

Select the database to be imported then right-click the Tools -> Execute Script menu.

Search and select the database to import, then click Start.

Wait for the execute process to finish, and import the database successfully.