I am confused and curious. Can you please elaborate on how streaming is related to pg storage?
You CAN stream bytea but:
* Good luck finding a client that supports it(npgsql does actually)
* It doesn't support support start the read/write at any location other than the start. So you'd have to basically build the Lob(Large Object) functionality yourself on top to support upload resume and other use cases.
With Lob even if your client doesn't support streaming, you can mimick it by writing chunks into the Lob.
Does each interaction essentially create a SQL update statement? And are you trying to avoid buffering those statements?