Export Postgresql table data using pgAdmin
- Right-click on your table and pick option
Backup.. - On File Options, set Filepath/Filename and pick
PLAINfor Format - Ignore Dump Options #1 tab
- In Dump Options #2 tab, check
USE INSERT COMMANDS - In Dump Options #2 tab, check
Use Column Insertsif you want column names in your inserts. - Hit
Backupbutton
Just right click on a table and select "backup". The popup will show various options, including "Format", select "plain" and you get plain SQL.
pgAdmin is just using pg_dump to create the dump, also when you want plain SQL.
It uses something like this:
pg_dump --user user --password --format=plain --table=tablename --inserts --attribute-inserts etc.
In the pgAdmin4, Right click on table select backup like this
After that into the backup dialog there is Dump options tab into that there is section queries you can select Use Insert Commands which include all insert queries as well in the backup.
