4.2.2. Using pgAdmin

4.2.2.1. SQL query

../../_images/pgadmin_sqlquery.jpg

Running SQL commands in pgAdmin4

Note

  • Clicking the Query Tool icon or Tools/Query Tool from the menu bar opens the SQL Window. The SQL icon is active only when you’re connected to a database.

  • Clicking the Execute Script icon or F5 runs the written SQL commands.

  • More information : <https://www.pgadmin.org/docs/pgadmin4/latest/query_tool.html>

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

../../_images/pgadmin_backup.jpg
  • Click the option-tab and check the following options

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

Note