| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Gordan Bobic" <gordan(at)freeuk(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re: Data type for storing images? |
| Date: | 2001-03-13 18:25:56 |
| Message-ID: | 20505.984507956@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
"Gordan Bobic" <gordan(at)freeuk(dot)com> writes:
> More to the point, what would be a reason for not using bytea to
> replace BLOBs completely?
The fact that encoding/decoding is a pain in the neck :-(. The
lo_read/lo_write interfaces are a relatively convenient way to send
and receive binary data, but the ASCII input-output representation that
bytea uses is not.
We really need some binary-friendly data transmission interface like
lo_read/lo_write for bytea fields before they will be ready to take over
the world. I think Jan has some ideas about how to do that, but it's
not done yet.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brent R. Matzelle | 2001-03-13 19:25:46 | Re: psql win32 version? |
| Previous Message | Tom Lane | 2001-03-13 18:13:39 | Re: creating a view that shows relation name -> OID |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian P Millett | 2001-03-13 21:00:39 | Re: Compiling pgsql_perl5-1.9.0 |
| Previous Message | David Wall | 2001-03-13 17:15:42 | Re: Data type for storing images? |