[database] Export Postgresql table data using pgAdmin

I am using pgAdmin version 1.14.3. PostgreSQL database version is 9.1.

I got all Db script for table creation but unable to export all data inside tables. Could not find any option to export data in db script form.

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.

1. Right-click on your table and pick option Backup..
2. On File Options, set Filepath/Filename and pick PLAIN for Format
3. Ignore Dump Options #1 tab
4. In Dump Options #2 tab, check USE INSERT COMMANDS
5. In Dump Options #2 tab, check Use Column Inserts if you want column names in your inserts.
6. Hit Backup button