Hacker News new | ask | show | jobs
by Ambolia 560 days ago
What about binary blobs? I hate having to store them outside of the database and that you can't just do a dbdump/import to clone a project.
1 comments

Have you had a look at the bytea[1] type? It allows you to store binary objects up to 1GB and it's dumped transparently just like a string.

[1] https://www.postgresql.org/docs/current/datatype-binary.html