From: Jerome Alet <alet@librelogiciel.com>
To: Rod Taylor <pg@rbt.ca>
Cc: sreejith s <getsreejith@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Doubt :- Image_Insert
Date: Mon, 22 Nov 2004 15:09:24 +0100
Message-ID: <20041122140924.GA25819@mail.librelogiciel.com> (raw)
In-Reply-To: <1101131660.4697.362.camel@home>
References: <5d14ecf90411220541659b2d30@mail.gmail.com>
<1101131660.4697.362.camel@home>
Hi,
On Mon, Nov 22, 2004 at 08:54:20AM -0500, Rod Taylor wrote:
> On Mon, 2004-11-22 at 19:11 +0530, sreejith s wrote:
> > Hello friends I have a doubt,
> > Is it possible to insert images into a postgres db. What is its
> > datatype. Is its possible to insert jpeg images. or v have to store
> > the path into the db. Pls reply. its urgent.
>
> Use bytea for a datatype. PostgreSQL can comfortably handle 50MB's worth
> of data and uncomfortably handle 1GB if you have enough RAM per tuple.
You mean "handle 50MB's worth of data" per tuple or as a whole ?
Same question for 1GB.
this is not really clear...
bye
Jerome Alet
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alet@librelogiciel.com, pg@rbt.ca, getsreejith@gmail.com
Subject: Re: Doubt :- Image_Insert
In-Reply-To: <20041122140924.GA25819@mail.librelogiciel.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox