How to store array of Python dicts in PostgreSQL?

Question

I have a Django project and such array in it:

{(0,0):{'a':True,'b':False ... },(0,1):{'a':True,'b':True ... },(1,1):{'a':True,'b':False ... }... }

I need to store this array in PostgreSQL database. I thought the ArrayField could help, but I just have no idea how to declare such array. I've read https://docs.djangoproject.com/en/1.8/ref/contrib/postgres/fields/
but there was not my situation. Could you show me an example?

I'm using Django 1.8

Yes you can JSON fields, also make sure that your postgres version should be 9.4 or higher, that only supports json field. — Sathish Kumar VG
– Sathish Kumar VG, Commented Apr 21, 2017 at 4:38

Aswin Kumar K P · Accepted Answer · 2017-04-21 02:08:46Z

1

JSON field should be perfect for you. https://docs.djangoproject.com/en/dev/ref/contrib/postgres/fields/#querying-jsonfield

from django.contrib.postgres.fields import JSONField
from django.db import models

class ModelName(models.Model):
    json_data = JSONField()

Now to save the data,

ModelName.objects.create(json_data={(0,0):{'a':True,'b':False ... },(0,1):{'a':True,'b':True ... },(1,1):{'a':True,'b':False ... }... })

answered Apr 21, 2017 at 2:08

Aswin Kumar K P

1,1122 gold badges12 silver badges23 bronze badges

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

Comments

Evan Carroll · Accepted Answer · 2017-04-21 02:00:36Z

0

PostgreSQL has two types you may want to check out,

Both have overlapping functionality. JSON is part of the SQL 2016 spec though; hstore while having some advantages on JSONB is a PostgreSQL thing

answered Apr 21, 2017 at 2:00

Evan Carroll

1

1 Comment

Pachvarsh Over a year ago

Looks like i should use newer version of Django to solve my problem

Collectives™ on Stack Overflow

How to store array of Python dicts in PostgreSQL?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related