Is there a way to stream a large-ish `bytea` to the database?

Question

Is there a way to stream a large-ish `bytea` to the database?

Closed this issue a year ago · 2 comments

It seems that BinaryCopyInWriter only works for full rows, but I would like to a single bytea field into the database as it is received from the network. Is this possible?

Answer 1 · 2024-09-04T19:28:35.000Z

There's no way to do that with the built-in BinaryCopyInWriter. You could make a custom writer that would be able to do that (you do need to know the size of the buffer and the overall row up-front). IIRC Postgres will buffer the entire row in memory though regardless.

Depending how big these values are, you may want to consider using the large value API, which allows "real" streaming to and from the backend.

Answer 2 · 2024-09-04T19:40:05.000Z

Thanks. I found your crate postgres_large_object.