CODEWITHSUNDEEP
sqlpostgresqlcompressionzlib
Rhubarb
Rhubarb

Reputation: 4003

Postgres' text column doesn't like my zlib compressed data

Is there a better data type to be using to store a zlib compressed string in Postgresql?

Upvotes: 5

Views: 3296

Answers (2)

halfdan
halfdan

Reputation: 34214

Use a bytea. Zip compressed data is not a text.

Upvotes: 4

nos
nos

Reputation: 229128

Use bytea "The bytea data type allows storage of binary strings"

Upvotes: 8

Related Questions