Re: 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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)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!