CODEWITHSUNDEEP
databasepostgresqlexportpgadmin
Muhammad Imran Tariq
Muhammad Imran Tariq

Reputation: 23352

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.

Upvotes: 168

Views: 336540

Answers (3)

Yusuf
Yusuf

Reputation: 2569

  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

Edit: In case you are using pgAdmin on a remote server: Once the UI announces the backup was successful, you might want to download the data. For this, follow these steps:

  1. Click on Tools (in the menu)
  2. Select Storage Manager
  3. Select the file that was just created
  4. Click on the small "Download File" button

Upvotes: 235

Keyur Lakhani
Keyur Lakhani

Reputation: 4381

In the pgAdmin4, Right click on table select backup like this

enter image description here

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.

enter image description here

Upvotes: 24

Frank Heikens
Frank Heikens

Reputation: 127446

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.

Upvotes: 168

Related Questions