From: | "Leonel Nunez" <listas(at)enelserver(dot)com> |
---|---|
To: | "Koen Vermeer" <koen(at)vermeer(dot)tv> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Storing images as BYTEA or large objects |
Date: | 2008-02-13 00:16:30 |
Message-ID: | 33025.189.155.240.224.1202861790.squirrel@enelserver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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/
>
With Java , Python , Perl you've got functions that escapes the data for
you
Leonel
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Johanson | 2008-02-13 00:17:06 | Re: SELECT CAST(123 AS char) -> 1 |
Previous Message | Ivan Sergio Borgonovo | 2008-02-12 23:52:02 | Re: end of life for pg versions... |