How to store gif or jpeg? Thanks!

Started by Maurizio Ortolanalmost 25 years ago5 messagesgeneral
Jump to latest
#1Maurizio 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?

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)

#2Nelson Ferreira Jr
nelson@radix.com.br
In reply to: Maurizio Ortolan (#1)
Re: How to store gif or jpeg? Thanks!

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:

Show quoted text

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

#3Peter T Mount
peter@retep.org.uk
In reply to: Maurizio Ortolan (#1)
Re: [SQL] How to store gif or jpeg? Thanks!

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/

#4Sylte
Sylte_@hotmail.com
In reply to: Peter T Mount (#3)
Re: How to store gif or jpeg? Thanks!

src/interfaces/jdbc/example/ImageViewer.java

Somewhere on the internet???? Please be more specific....

#5Mathijs Brands
mathijs@ilse.nl
In reply to: Sylte (#4)
Re: Re: How to store gif or jpeg? Thanks!

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.