Re: Record

From: Alvaro Herrera <alvherre(at)atentus(dot)com>
To: Aasmund Midttun Godal <postgresql(at)envisity(dot)com>
Cc: <julio(at)bntsoft(dot)com(dot)br>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Record
Date: 2001-10-24 14:22:39
Message-ID: Pine.LNX.4.33L2.0110241121000.25995-100000@aguila.protecne.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[(at)]atentus(dot)com>)
Jajaja! Solo hablaba en serio!

In response to

  • Re: Record at 2001-10-23 22:04:35 from Aasmund Midttun Godal

Responses

  • Re: Record at 2001-10-24 15:19:47 from Aasmund Midttun Godal

Browse pgsql-general by date

  From Date Subject
Next Message qk22 2001-10-24 14:23:59 Re: Can not input large text data
Previous Message Paul Green 2001-10-24 14:21:44 Using other database tables in a query