Graphics Supported?

Started by Bernieabout 27 years ago4 messagesgeneral
Jump to latest
#1Bernie
bfb@att.net

Is it possible to store a gif or jpg image
in a PG database, then retrieve the image
and display it on a web page?

If so, how do you create the table?

-Thanks

#2Clark Evans
clark.evans@manhattanproject.com
In reply to: Bernie (#1)
Re: [GENERAL] Graphics Supported?

I believe this would be done using
the large object support. This detailed
in the programmers's manual page 96-99.

I would also look at php3.org, although
I'm not sure if they are supporting
large objects in the database.

Clark

Perhaps
is explained well atis detailed in the Bernie wrote:

Show quoted text

Is it possible to store a gif or jpg image
in a PG database, then retrieve the image
and display it on a web page?

If so, how do you create the table?

-Thanks

#3Tim Williams
williams@ugsolutions.com
In reply to: Bernie (#1)
Re: [GENERAL] Graphics Supported?

Is it possible to store a gif or jpg image
in a PG database, then retrieve the image
and display it on a web page?

If so, how do you create the table?

-Thanks

To propose something horribly simple and direct, perhaps it would
make more sense to actually just store the files on disk and then
simply provide the URL of the file from the database. Otherwise you're
faced with the issue of using TWO hits (read database calls) to deliver
both the image file (one web page) and its related data (another page).

2 cents,
- Tim

#4Peter T Mount
peter@retep.org.uk
In reply to: Bernie (#1)
Re: [GENERAL] Graphics Supported?

On Wed, 13 Jan 1999, Bernie wrote:

Is it possible to store a gif or jpg image
in a PG database, then retrieve the image
and display it on a web page?

If so, how do you create the table?

Take a look at the ImageViewer example that's included with the JDBC
driver (src/interfaces/jdbc/example)

Peter

--
Peter T Mount peter@retep.org.uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf