Creating table's SQL dump in pgAdmin PostgreSQL

Owned by Wojciech Mozolewski
15 Oct 2019
2 min read

Very often, issues reported by our clients are caused by incorrect/corrupted entries in the tables (which store the data). In such cases, we usually ask to export and send us these tables for investigation. It is always possible to quickly export a table by using DataPump’s export script or Earthlight’s Export tool, however, these tools allow you to export data to specified formats (shp, tab, csv etc.). Our data exporting engines are very often fixing incorrect values and we are no longer able to reproduce the issue by using provided data. We strongly suggest to create SQL dump of the corrupted table because only this method guarantees that the data are exported in exact same format/value as they are stored in your database.

To create SQL dump of the desired table please follow these steps.

 

  1. Locate table you want to create SQL dump of, right-click on it and select “Backup”.

2. Fill information in the Backup window General tab outlined in the screenshot below. Set Format to Plain.

3. Go to ‘Dump options’ tab and select Yes for Pre-data, Post-data and Data options in Sections.

4. Now scroll down to the ‘Queries’ section and choose 'Yes' for ‘Use Insert Commands’ option.

5. When all options are set and the location for the newly created SQL dump file is chosen you can click on Backup to create a file.