Create an SQL inserting script from Django to populate a PostgreSQL database

Question

I'm currently trying to insert in a Django model some complex data extracted from multiple parsed files. Because I have a huge amount of data to insert I don't want to multiply the queries to the database from my Django script.

Is there a way to generate an SQL script instead of executing all the object_to_insert.save() and inserting the script by using psql -f my_script.sql ?

Jean Jung · Accepted Answer · 2016-01-15 14:01:22Z

2

If it's only one table, there is a bulk_create method in the Django ORM queryset: https://docs.djangoproject.com/en/stable/ref/models/querysets/#bulk-create

This method takes a list of objects and insert them on the database by an an efficient way, generally in only one query if the database supports multiple inserts.

answered Jan 15, 2016 at 14:01

Jean Jung

1,21014 silver badges30 bronze badges

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

3 Comments

Thibaut Guirimand Over a year ago

It's a very interesting possibility but I have multiple interconnected tables so it's not the most optimized solution I can imagine.

Jean Jung Over a year ago

You know the primary key of all objects being inserted?

Thibaut Guirimand Over a year ago

I define some primary keys but there is some tables with linked objects that use the django default serial field as primary key. I think it could be a problem to create an insertion script.

Collectives™ on Stack Overflow

Create an SQL inserting script from Django to populate a PostgreSQL database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related