Peter Eisentraut <peter_e@gmx.net> writes:
> Bruce Momjian writes:
> Please, consider a BLOB column type without having to do lo_import,
> lo_export.
>>
>> Yep, big needed item.
> Maybe we could make the BLOB type a wrapper around the lo_* functions?
> The BLOB value would only store the oid.
What for/why bother? A toastable bytea column would do just as well.
What we need is an easy-to-use set of access functions, which we haven't
got in either case (without additional work).
I'd prefer to see that work invested in access functions for toasted
columns, because LOs have all sorts of administrative problems ---
security and garbage collection, to name two. We don't really want to
encourage their use in the long term.
regards, tom lane