bytea / large object and image

From: "Alain Roger" <raf(dot)news(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: bytea / large object and image
Date: 2006-11-04 17:24:54
Message-ID: 75645bbb0611040924g3008d333n57e89de3ee0ac3b9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I create a table with some large object (ref: OID) to store some images.
When my PHP will display some data, it will also display the images stored
as OID.

However, i've read that before i must restore the image by exporting them to
local (on server) file.

isn't it easier in this case, to simply store the path and file name of file
to DB and just read the data to display image on PHP pages ?
what is the purpose in this case to store image a bytea / large object ?

thanks a lot,

Al.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2006-11-04 17:28:08 Re: Simple stored procedure examples?
Previous Message Alain Roger 2006-11-04 16:44:16 Re: UNICODE and UTF-8