Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 10 down vote favorite

I have an array field in my PostrgreSQL database of type text. Is there a way to map this into a Django model ?

share|improve this question
3  
possible duplicate of how does django model after text[] in postgresql – Milen A. Radev Dec 9 '10 at 17:31

4 Answers

up vote 8 down vote accepted

You might want to look into django-dbarray on github. It adds support for postgresql array fields.

I haven't used it before, but it looks like you just need to do:

from django.db import model
import dbarray

class ProfilingTestRun(models.Model):
    function = models.CharField(max_length=64)
    runtimes = dbarray.FloatArrayField()
share|improve this answer
up vote 4 down vote

One of the other nice options is http://django-orm.readthedocs.org/ --- a library that adds bindings to many native postgres types.

Main drawback of django-orm is that as of today it has no working support for south.

share|improve this answer
up vote 1 down vote

you have to subclass model.Field and write input and output methods.

http://docs.djangoproject.com/en/dev/howto/custom-model-fields/#custom-database-types

share|improve this answer
up vote 1 down vote

djorm-ext-pgarray also offer queries http://www.niwi.be/2012/10/07/postgresql-array-fields-with-django/

share|improve this answer
1  
This now seems like a better option than django-dbarray as it's better maintained. dbarray doesn't work for CharField arrays in its current form (though there is an outstanding pull request which apparently fixes this) – alan Mar 3 at 23:12

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.