2

I read a few similar posts and find that they did not specify how to export SQLs to custom files. I will walk through steps with screenshots here.

reference reference

Yu Tian Toby
  • 209
  • 1
  • 4
  • 11

2 Answers2

8
  1. right click on a table/schema/database and click 'Backup' in the menu.

enter image description here

  1. set export file format to 'Plain'

enter image description here

  1. select the custom file created to save the backup scripts

enter image description here

and double click to confirm

enter image description here

  1. open 'dump options' tab to set dump options

enter image description here

  1. set dump options

enter image description here

enter image description here

  1. set 'Use INSERT commands' so the exported sql is runnable when original table/schema/database is deleted

enter image description here

  1. click 'Backup' button to start process

enter image description here

  1. PgAdmin shows success message when backup is done

enter image description here

Yu Tian Toby
  • 209
  • 1
  • 4
  • 11
2

There is a Store Manager under Tools that allows you to download a backup explained in the answer above. Took me a while to find it. Hope this helps.

enter image description here

enter image description here

Saša Kalaba
  • 4,241
  • 6
  • 29
  • 52