Postgres/python django import json dump database

Question

I got json database dump file to import into postgres but this file is not sql file (which I know how to import) it is json file. Its structure looks like this:

[
    {
      "model": "model.name",
      "pk": 1,
      "fields": {
        "version": 1584369114566125,
        "field_a": "something",
        "field_b": "something"
      }
    },
    {
        "model": "model.name",
        "pk": 1,
        "fields": {
            "version": 1584369114566125,
            "field_a": "something",
            "field_b": "something"
        }
    },
    ...
]

I want to import it but I don't know if is there option for importing database in such format and structure without writing sql function? I was trying to find if there is in documentation of pg_dump any option for exporting in json but I didn't find. My guess is also that server is written in django and maybe django has script for exporting/importing database in such file?

Selcuk · Accepted Answer · 2020-09-02 06:40:08Z

2

The format you posted looks like a fixture:

You’ll store this data in a fixtures directory inside your app. [...] You can load data by calling manage.py loaddata <fixturename>, where <fixturename> is the name of the fixture file you’ve created. Each

answered Sep 2, 2020 at 6:40

Selcuk

60.1k12 gold badges114 silver badges119 bronze badges

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

Collectives™ on Stack Overflow

Postgres/python django import json dump database

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