Re: bytea / large object and image

From: "Raymond O'Donnell" <rod(at)iol(dot)ie>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: bytea / large object and image
Date: 2006-11-04 18:38:20
Message-ID: 454CDE1C.28654.12333DA@rod.iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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
----------------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-11-04 18:43:07 Re: bytea / large object and image
Previous Message Scott Ribe 2006-11-04 18:12:12 Re: fetching unique pins in a high-transaction