Thread: 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

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:
>
> 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

> 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

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