Re: can i display an image _directly_ from postgres db storage?

Jason Wong wrote:

On Tuesday 02 November 2004 03:36, P. George wrote:

i know that postgres has a raw binary datatype called bytea for storing pictures and whatnot, but i'm having trouble finding an example of displaying an image on a web page with php that is pulled directly from the database? is this possible? You probably don't want to use bytea as it will use a lot of

ram for larger images. Instead you will want to look at large objects. The functions you want are: *pg_loreadall()* *pg_lo_read_all()* <http://www.php.net/manual/en/function.pg-lo-read-all.php> *pg_locreate()* *pg_lo_create()* <http://www.php.net/manual/en/function.pg-lo-create.php> *pg_lounlink()* *pg_lo_unlink()* <http://www.php.net/manual/en/function.pg-lo-unlink.php> *pg_loopen()* *pg_lo_open()* <http://www.php.net/manual/en/function.pg-lo-open.php> *pg_loclose()* *pg_lo_close()* <http://www.php.net/manual/en/function.pg-lo-close.php> *pg_loread()* *pg_lo_read()* <http://www.php.net/manual/en/function.pg-lo-read.php> *pg_lowrite()* *pg_lo_write()* <http://www.php.net/manual/en/function.pg-lo-write.php> *pg_loimport()* *pg_lo_import()* <http://www.php.net/manual/en/function.pg-lo-import.php> *pg_loexport()* *pg_lo_export()* <http://www.php.net/manual/en/function.pg-lo-export.php> Sincerely, Joshua D. Drake

Yes.

if so, how?

Tutorials that shows how to upload and store image/binary files in a database also usually shows how to retrieve them (and in the case of images, also how to display them). One function you'll find useful is imagecreatefromstring()

-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL