Thread: How to store gif or jpeg? Thanks!
Hello!
In your opinion, which is the best
way to store images (gif o jpg)
with PostgreSQL?
Where can I find an easy example?
Many thanks to all of you!
CIAO!
MAURIZIO
*******************************************
** Happy surfing on THE NET !! **
** Ciao by **
** C R I X 98 **
*******************************************
AntiSpam: rimuovere il trattino basso
dall'indirizzo per scrivermi...
(delete the underscore from the e-mail address to reply)
Hello! When you store data with PostgreSQL as BLOBs it doesn't matter if it's an image, sound or whatever - everything works in the same way. So you should use the image type that better represents your images. You can find some information about how to use it below: psql: (see the commands \lo_[something] ) http://www.postgresql.org/devel-corner/docs/postgres/app-psql.html client interfaces: http://www.postgresql.org/devel-corner/docs/postgres/programmer-client.html Nelson. Maurizio Ortolan wrote: > Hello! > > In your opinion, which is the best > way to store images (gif o jpg) > with PostgreSQL? > > Where can I find an easy example? > > Many thanks to all of you! > CIAO! > MAURIZIO > > ******************************************* > ** Happy surfing on THE NET !! ** > ** Ciao by ** > ** C R I X 98 ** > ******************************************* > AntiSpam: rimuovere il trattino basso > dall'indirizzo per scrivermi... > (delete the underscore from the e-mail address to reply) > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
Quoting Maurizio Ortolan <crix98__@tin.it>: > Hello! > > In your opinion, which is the best > way to store images (gif o jpg) > with PostgreSQL? > > Where can I find an easy example? src/interfaces/jdbc/example/ImageViewer.java -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
> src/interfaces/jdbc/example/ImageViewer.java Somewhere on the internet???? Please be more specific....
On Tue, May 08, 2001 at 03:16:53PM +0200, Sylte allegedly wrote: > > src/interfaces/jdbc/example/ImageViewer.java > > Somewhere on the internet???? Please be more specific.... It's part of the PostgreSQL source. You can download the PostgreSQL source from www.postgresql.org... Regards, Mathijs -- And the beast shall be made legion. Its numbers shall be increased a thousand thousand fold. The din of a million keyboards like unto a great storm shall cover the earth, and the followers of Mammon shall tremble.