How to store None as JSON 'null' rather than SQL NULL?

Asked Aug 24 '18 at 22:55

Active Aug 24 '18 at 22:55

Viewed 254 times

I'm using contrib.postgres.fields.JSONField to store some JSON data with Django 1.11.

Contrary to the convention described in this answer, I'd like to store None as JSON. However, Django by default tries to store None as SQL NULL, and errors if I set the field to null=False.

Is there any way to get Django to store None as 'none'::jsonb?

asked Aug 24 '18 at 22:55

Felipe

3,003
2
26
44

have you tried replacing all `None`s with the string `null`. – Ashish Acharya Aug 24 '18 at 23:06
Yep -- I get `'"null"'::jsonb` in the DB then – Felipe Aug 24 '18 at 23:07
`import json` and then `json.dumps(None)` would might help. – D. S Aug 24 '18 at 23:27
@D.S That's the same suggestion as the previous comment – Felipe Aug 25 '18 at 14:30

How to store None as JSON 'null' rather than SQL NULL?

0 Answers0