Re: Storing images as BYTEA or large objects

Hi,

Which programming language are you using?

Regards,
Gevik Babakhani
------------------------------------------------
PostgreSQL NL http://www.postgresql.nl
TrueSoftware BV http://www.truesoftware.nl
------------------------------------------------

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Koen Vermeer
> Sent: Tuesday, February 12, 2008 11:41 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Storing images as BYTEA or large objects
>
> Hi,
>
> I would like to store binary data in a PostgreSQL database.
> The size of the data is about 2 to 20 MB and is always stored
> or retrieved as a block (i.e., I do not need to get only part
> of the data). As I understand, I have two options for storing
> this data: As BYTEA or as large objects. As I understand, the
> disadvantage of the first method is that I need to write a
> custom routine to escape some binary values - or is there
> some code available to do this? The disadvantage of large
> objects is their existence outside of the main database,
> which may be problematic when backing up a database. In
> addition, I need special routines to store/retrieve the data.
>
> My two questions are: Is this summary correct? And: Which
> method should I choose?
>
> Best,
> Koen
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>