Thread

1. How to store gif or jpeg? Thanks!

   Maurizio Ortolan <crix98__@tin.it> — 2001-04-15T17:17:18Z

   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)
   
   
   

2. Re: How to store gif or jpeg? Thanks!

   Nelson Ferreira Jr <nelson@radix.com.br> — 2001-04-15T18:52:56Z

      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
   
   
   

3. Re: [SQL] How to store gif or jpeg? Thanks!

   Peter T Mount <peter@retep.org.uk> — 2001-04-20T10:54:38Z

   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/
   
   

4. Re: How to store gif or jpeg? Thanks!

   Sylte <sylte_@hotmail.com> — 2001-05-08T13:16:53Z

   > src/interfaces/jdbc/example/ImageViewer.java
   
   Somewhere on the internet???? Please be more specific....
   
   
   
   

5. Re: Re: How to store gif or jpeg? Thanks!

   Mathijs Brands <mathijs@ilse.nl> — 2001-05-11T20:18:38Z

   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.