bytea and text

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: bytea and text
Date: 2009-11-26 14:44:58
Message-ID: 4B0E946A.8020905@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi list,

I'm asking myself what solution for storing pictures is the best:

* using a BYTEA column type, and having no intrinsic compression gain
because a picture it almost every time already compressed,

* using a TEXT column type, and store a Base64(picture) in it; it should
take benefits of intrinsic compression (?).

JY
--

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Brian Modra 2009-11-26 14:52:15 Re: bytea and text
Previous Message Nathaniel Trellice 2009-11-26 14:27:20 Re: Bit count