4.2.2. Using pgAdmin
4.2.2.1. SQL query
Note
Clicking the highlighted icon at location 1 opens the SQL Window. The SQL icon is active only when you’re connected to a database.
Clicking the icon at 2 runs the written SQL commands.
4.2.2.2. Database dump
Note
Open pgAdmin4 and connect to the database
Right click the Schema that you want to backup (in the tree structure below “Schemas”)
Enter the filename where the dump should be stored
Click the option-tab and check the following options
Note
After running the process, the window in the right bottom shows that everything went ok