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: (view raw, whole thread or download thread mbox)
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 (?).



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-2017 The PostgreSQL Global Development Group