Re: How to store gif or jpeg? Thanks!

From: Nelson Ferreira Jr <nelson(at)radix(dot)com(dot)br>
To: Maurizio Ortolan <crix98__(at)tin(dot)it>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to store gif or jpeg? Thanks!
Date: 2001-04-15 18:52:56
Message-ID: 3AD9EE08.99E8C99A@radix.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dustin sallings 2001-04-15 19:23:40 7.1 slowed down my query
Previous Message Dominic J. Eidson 2001-04-15 17:57:35 Re: Benchmarking PostgreSQL

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-04-15 19:52:30 Re: Re: [SQL] g++ not working for postgresql extension languages?
Previous Message Lonnie Cumberland 2001-04-15 18:20:11 Re: Re: [SQL] g++ not working for postgresql extension languages?