Re: Record - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Record
Date
Msg-id Pine.LNX.4.33L2.0110241121000.25995-100000@aguila.protecne.cl
Whole thread Raw
In response to Re: Record  ("Aasmund Midttun Godal" <postgresql@envisity.com>)
Responses Re: Record  ("Aasmund Midttun Godal" <postgresql@envisity.com>)
List pgsql-general
On Tue, 23 Oct 2001, Aasmund Midttun Godal wrote:

> I am not sure I understand what you mean. However if you are wanting to store an image in a table you have 2 options:
>
> 1. bytea fields.
> 2. large objects.

Third option is to encode the image (base64?) and then store as text.
It's probably slower (since you have to decode it everytime), uses much
more space, but you don't have to worry about escaping the byte
sequence.

--
Alvaro Herrera (<alvherre[@]atentus.com>)
Jajaja! Solo hablaba en serio!


pgsql-general by date:

Previous
From: "Dominic J. Eidson"
Date:
Subject: Re: Disable Transaction - plans ?
Next
From: Alvaro Herrera
Date:
Subject: Re: MATCH FULL flawed?