Is there a better data type to be using to store a zlib compressed string in Postgresql?
Citing sources last updated 8 years ago when up to date and authoritative sources exist is probably more confusing than helpful.
Milen A. Radev
2010-06-02 13:35:00
`bytea` , as by other answer, is what corresponds, in Postgresql, to the BLOB concept.
leonbloy
2010-06-02 15:55:47
Interesting. Any idea what this would be in Django? Meaning what Django field type would yield this type in Postgres?
Rhubarb
2010-06-02 13:31:47
Apparently django doesn't support bytea directly - see http://stackoverflow.com/questions/517349/binaryfields-in-django-models , You could e.g. base64 encode your data and continue to use a text field - though you'd lose some of the benefit of compression
nos
2010-06-02 13:41:49