Re: bytea / large object and image - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: bytea / large object and image
Date
Msg-id 454CDE1C.28654.12333DA@rod.iol.ie
Whole thread Raw
In response to bytea / large object and image  ("Alain Roger" <raf.news@gmail.com>)
Responses Re: bytea / large object and image
List 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@iol.ie
----------------------------------------------------------------------



pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: fetching unique pins in a high-transaction
Next
From: Tomas Vondra
Date:
Subject: Re: bytea / large object and image