| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Where to store Blobs? |
| Date: | 2019-03-13 15:55:25 |
| Message-ID: | 20190313155525.GB3145@hermes.hilbert.loc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2019-03-13 16:29:21 | Re: Where to store Blobs? |
| Previous Message | Christopher Browne | 2019-03-13 15:50:37 | Re: Where to store Blobs? |