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 <avin_friends@xxxxxxxxx> wrote: > From: aravind chandu <avin_friends@xxxxxxxxx> > Subject: [GENERAL] To store and retrive image data in postgresql > To: pgsql-general@xxxxxxxxxxxxxx > Date: Monday, July 7, 2008, 7:22 PM > 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? > > > > Thank You, > > Avinash.