pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedDoubt :- Image_Insert
4+ messages / 3 participants
[nested] [flat]
* Doubt :- Image_Insert
@ 2004-11-22 13:41 sreejith s <getsreejith@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: sreejith s @ 2004-11-22 13:41 UTC (permalink / raw)
To: pgsql-sql
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.
Sreejith
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Doubt :- Image_Insert
@ 2004-11-22 13:54 Rod Taylor <pg@rbt.ca>
parent: sreejith s <getsreejith@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Rod Taylor @ 2004-11-22 13:54 UTC (permalink / raw)
To: sreejith s <getsreejith@gmail.com>; +Cc: pgsql-sql
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 will need to properly escape the data to do the insertion, but the
documentation (for DBI, PHP, Java, and PostgreSQL for the others) all
clearly explain the steps to be taken.
--
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Doubt :- Image_Insert
@ 2004-11-22 14:09 Jerome Alet <alet@librelogiciel.com>
parent: Rod Taylor <pg@rbt.ca>
0 siblings, 1 reply; 4+ messages in thread
From: Jerome Alet @ 2004-11-22 14:09 UTC (permalink / raw)
To: Rod Taylor <pg@rbt.ca>; +Cc: sreejith s <getsreejith@gmail.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Doubt :- Image_Insert
@ 2004-11-22 14:10 Rod Taylor <pg@rbt.ca>
parent: Jerome Alet <alet@librelogiciel.com>
0 siblings, 0 replies; 4+ messages in thread
From: Rod Taylor @ 2004-11-22 14:10 UTC (permalink / raw)
To: Jerome Alet <alet@librelogiciel.com>; +Cc: sreejith s <getsreejith@gmail.com>; pgsql-sql
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.
--
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-11-22 14:10 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-22 13:41 Doubt :- Image_Insert sreejith s <getsreejith@gmail.com>
2004-11-22 13:54 ` Rod Taylor <pg@rbt.ca>
2004-11-22 14:09 ` Jerome Alet <alet@librelogiciel.com>
2004-11-22 14:10 ` Rod Taylor <pg@rbt.ca>
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