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)
