Re: [GENERAL] To store and retrive image data in postgresql

2008-07-07 Thread Tino Wildenhain
Hi, Craig Ringer wrote: Brent Wood wrote: ... I need to store an image in postgresql database and after that i need to retrive the image back.Can you please help me how to do this? ... - Storing image data in the DB is probably much less efficient in storage space and for access

Re: [GENERAL] To store and retrive image data in postgresql

2008-07-07 Thread Craig Ringer
Brent Wood wrote: aravind chandu <[EMAIL PROTECTED]> 07/08/08 10:30 AM >>> > Hello, > > I need to store > an image in postgresql database and after that i need to retrive the > image back.Can you please help me how to do this? > > > > Hi, > > I have been involved in building a f

Re: [GENERAL] To store and retrive image data in postgresql

2008-07-07 Thread Brent Wood
>>> aravind chandu <[EMAIL PROTECTED]> 07/08/08 10:30 AM >>> Hello, I need to store an image in postgresql database and after that i need to retrive the image back.Can you please help me how to do this? Hi, I have been involved in building a few applications to manage this capability

Re: [GENERAL] To store and retrive image data in postgresql

2008-07-07 Thread Christophe
On Jul 7, 2008, at 12:22 PM, aravind chandu wrote: I need to store an image in postgresql database and after that i need to retrive the image back.Can you please help me how to do this? Assuming you mean an image as in a binary visual image (like a JPEG), the data type you want is

Re: [GENERAL] To store and retrive image data in postgresql

2008-07-07 Thread Lennin Caro
for hot_backup and restore check this http://www.postgresql.org/docs/8.3/static/continuous-archiving.html for logic backup (dump) use this http://www.postgresql.org/docs/8.3/static/app-pgdump.html --- On Mon, 7/7/08, aravind chandu <[EMAIL PROTECTED]> wrote: > From: aravind chandu <[EMAIL P