Received: from gandalf.radix.com.br ([200.249.104.5]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3FIr6u07051 for ; Sun, 15 Apr 2001 14:53:07 -0400 (EDT) (envelope-from nelson@radix.com.br) Received: (qmail 24262 invoked from network); 15 Apr 2001 19:49:59 -0000 Received: from castor-frontend.radix.com.br (HELO radix.com.br) (200.249.104.8) by gandalf.radix.com.br with SMTP; 15 Apr 2001 19:49:59 -0000 Message-ID: <3AD9EE08.99E8C99A@radix.com.br> Date: Sun, 15 Apr 2001 15:52:56 -0300 From: Nelson Ferreira Jr X-Mailer: Mozilla 4.7 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: Maurizio Ortolan CC: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: How to store gif or jpeg? Thanks! References: <5.0.2.1.2.20010415101622.01e3ec78@box.tin.it> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/) X-Archive-Number: 200104/619 X-Sequence-Number: 7767 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