Create insert script from query result

Question

A few times a week, I need to create SQL insert scripts from query results in pgAdmin III.

Currently, I do this manually. Is there a function in pgAdmin to export a query result to an SQL Insert script ? I use a postgreSQL database.

Or is there another (open source) tool which can do this ? I'm running Ubuntu Linux.

Thanks

Marlon Abeykoon · Accepted Answer · 2016-07-31 15:25:33Z

3

Currently there is no feature as such in pgadmin refer this. But you can use pg_dump. First create a table to export the result to a table as follows.

create table ex_table as 
select id, col1, col2
from table
where col3 = 'value1'

Then pg_dump as follows,

$ pg_dump --table=ex_table --data-only --column-inserts my_database > data_with_inserts.sql

Another alternative is to use this SQL Workbench tool.

edited Jul 31, 2016 at 15:25

answered Jul 31, 2016 at 15:19

Marlon Abeykoon

12.6k4 gold badges60 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create insert script from query result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related