New answers tagged blob
The idea behind the large object API is to mimic a file-like API. The OID is like the path of the file, and the file descriptor obtained by lo_open or lo_creat is the equivalent of the POSIX open() and creat() system calls for files. JDBC provides LargeObject.truncate() and the both libpq (in C) and the server have built-in lo_truncate() functions. So yes ...
I have experimented with the tool and confirmed that deleting the stub files does not delete the Azure blob. I had to set up a PowerShell script to cleanup the file blobs.
Top 50 recent answers are included