Y
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
taffer
560 days ago
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
link
[1] https://www.postgresql.org/docs/current/datatype-binary.html