From: sandhya <sandhyar@amiindia.co.in>
To: andy.shellam@mailnetwork.co.uk
Cc: pgsql-admin@postgresql.org
Subject: Re: regarding image files in DB
Date: Thu, 11 May 2006 13:15:52 +0530
Message-ID: <029d01c674ce$edb3daf0$cd00000a@sandhyar> (raw)
References: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAAC4AAAAAAAAAt+qV6pqKPEmXG74T lFgX5gEAlpDSN+DrMEWnumhoRHpQKQAAAbLc9wAAEAAAADCWg22kkrFPiTsomYTy0/EBAAAAAA= =@mailnetwork.co.uk>
Is there any document which explains clarly about how to load files in binart format and how to retrieve it....As far as i read i got only files storing in OID format.
Thanks for your help...
Sandhya
----- Original Message -----
From: Andy Shellam
To: 'sandhya'
Cc: pgsql-admin@postgresql.org
Sent: Thursday, May 11, 2006 12:56 PM
Subject: RE: [ADMIN] regarding image files in DB
I would think a data type with the likes of "binary" (bytea?) would be more appropriate. It's like trying to upload an image via FTP in ASCII format - it never comes out the same the other end.
------------------------------------------------------------------------------
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of sandhya
Sent: 11 May 2006 6:19 am
To: Postgres
Cc: sandhya
Subject: [ADMIN] regarding image files in DB
Hi,
Please explain me is there any difference if i load my files(like gif or any images files) into the data base as text format?
Bcoz,I have loaded my image files in a text format into the database and when i exported it into my local file system the content of the original file(i.e. imported file into DB) and the exported file from the DB are different.
What is the wrong i did?In which format i have to load my file.Is it only for image files or for all types of files(like js,asp,htm etc)
Please help me in resolving this issue.
Thanks in advance
Regards,
Sandhya
!DSPAM:14,4462c7c434491454781929!
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: sandhyar@amiindia.co.in, andy.shellam@mailnetwork.co.uk
Subject: Re: regarding image files in DB
In-Reply-To: <029d01c674ce$edb3daf0$cd00000a@sandhyar>
References: <029d01c674ce$edb3daf0$cd00000a@sandhyar>
* 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