On Wed, Mar 13, 2019 at 11:50:37AM -0400, Christopher Browne wrote:
>> I guess most people do not store Blobs in PostgresSQL.
- BYTEA puts practical limits on size
- LO storage happens inside the system (!) table
Nowadays, there are Foreign Data Wrappers which might
encapsulate files as if they lived inside the database.
Also, a combination of
COPY TO FORMAT binary
pg_read_binary_file()
and suitable plpgsql security definer functions might provide
for a Poor Man's binary file integrated external storage.
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B