How to export Postgres schema/data to plain SQL in PgAdmin 4

Question

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

Answer 1

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

2. set export file format to 'Plain'

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

and double click to confirm

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

5. set dump options

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

7. click 'Backup' button to start process

8. PgAdmin shows success message when backup is done