From: Rod Taylor <pg@rbt.ca>
To: Jerome Alet <alet@librelogiciel.com>
Cc: sreejith s <getsreejith@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Doubt :- Image_Insert
Date: Mon, 22 Nov 2004 09:10:09 -0500
Message-ID: <1101132609.4697.364.camel@home> (raw)
In-Reply-To: <20041122140924.GA25819@mail.librelogiciel.com>
References: <5d14ecf90411220541659b2d30@mail.gmail.com>
<1101131660.4697.362.camel@home>
<20041122140924.GA25819@mail.librelogiciel.com>
On Mon, 2004-11-22 at 15:09 +0100, Jerome Alet wrote:
> 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 ?
Per tuple. There is no practical limit to how much it can handle as a
whole.
--
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: pg@rbt.ca, alet@librelogiciel.com, getsreejith@gmail.com
Subject: Re: Doubt :- Image_Insert
In-Reply-To: <1101132609.4697.364.camel@home>
* 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