Is there a PostgreSQL equivalent to the MSSQL FILESTREAM storage?

Question

I'm working on a application to manage certain (physical) items. Now I'd like to store images and other documents alongside with the structured data.

As far as I am able to tell, the two main ways to do it in postgres is to either put in the database, either as BLOBs or byteas, or to just put them in the filesystem. Both methods have some drawbacks I'd like to avoid.

From my experience with MSSQL I know that it offers the FileStream storage method, which seems like a good compromise between the two methods above and a pretty good fit for my needs. As I would rather not use MSSQL, I'm looking for something similar for postgres.

Answer 1

There is no equivalent.

Did you check if the large object API offers something that can help you?