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

User · Accepted Answer

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

User · Answer

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

User · Answer

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

[database] Export Postgresql table data using pgAdmin

Examples related to database

Examples related to postgresql

Examples related to export

Examples related to pgadmin