Re: bytea / large object and image

Raymond O'Donnell wrote:
> On 4 Nov 2006 at 18:24, Alain Roger wrote:
>
>> However, i've read that before i must restore the image by exporting
>> them to local (on server) file.
>
> You can use bytea type to store binary data directly in the database -
> if it's any use to you, I can send you some ASP code that does this.

bytea is not always a good idea. It depends on the size of the data you
are storing. If you are storing pretty much anything greater than 200k I
would suggest moving to pg_largeobject instead.

Joshua D. Drake

>
> There was a thread recently on the merits of doing it this way, as
> opposed to storing the image on the filesystem and keeping just
> metadata in the DB - you'll find it in the archives.
>
> --Ray.
>
>
>
> ----------------------------------------------------------------------
>
> Raymond O'Donnell
> Director of Music, Galway Cathedral, Galway, Ireland
> rod(at)iol(dot)ie
> ----------------------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--

SPI Liason, PostgreSQL Fundraising Group
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
Find out about PostgreSQL Fundraising: http://fundraising.postgresql.org/
Read the PostgreSQL docs: http://www.postgresql.org/docs/