Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Brian ModraDate: 2009-11-26 14:52:15
Subject: Re: bytea and text
Previous:From: Nathaniel TrelliceDate: 2009-11-26 14:27:20
Subject: Re: Bit count

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group