Export Postgresql table data using pgAdmin

Question

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.

Answer 1

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

Answer 2

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.