Postgres Pro
Downloads
Home   >   mailing lists

Thread: retrieving images stored by php / pgsql

retrieving images stored by php / pgsql

From
geert.pille@vandemoortele.com (Gerard H. Pille)
Date:
Hallo,

I have stored images (gif, jpeg, png and others) in a bytea column
using pg_escape_bytea ( file_get_contents (...)).

Now I would like to retrieve (and show) these images, but using
unixODBC.  I have no problem retrieving them using pgsql, but the
images are damaged when I try to do it with odbc.

What would be the correct way, if it is at all possible?

Thanks,

Gerard

Re: retrieving images stored by php / pgsql

From
"Raymond O'Donnell"
Date:
On 23 Apr 2005 at 12:43, Gerard H. Pille wrote:

> Now I would like to retrieve (and show) these images, but using
> unixODBC.  I have no problem retrieving them using pgsql, but the
> images are damaged when I try to do it with odbc.

Correct me if I'm wrong, but I think there's a limit (32k or
something) to the size of files you can retrieve from bytea via ODBC.

--Ray.


-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------