4.1.2. Using pgAdmin

4.1.2.1. SQL query

../../_images/sql-query4.jpg

Running SQL commands in pgAdmin4

Nota

  • 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.1.2.2. Database dump

Nota

  • 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

../../_images/database-dump-general4.jpg

  • Click the option-tab and check the following options

../../_images/database-dump-options4.jpg

Nota

  • After running the process, the window in the right bottom shows that everything went ok

../../_images/database-dump-complete4.jpg