X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7EC979FA32D for ; Thu, 11 May 2006 04:36:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 71329-02 for ; Thu, 11 May 2006 04:36:36 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id A9FDC9FA29F for ; Thu, 11 May 2006 04:36:33 -0300 (ADT) Received: from venus.amiindia.co.in (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with ESMTP id k4B7TiiW013174; Thu, 11 May 2006 12:59:50 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 3FA1533266C; Thu, 11 May 2006 12:59:44 +0530 (IST) Message-ID: <029401c674ce$b79a3720$cd00000a@sandhyar> From: "sandhya" To: Cc: References: Subject: Re: regarding image files in DB Date: Thu, 11 May 2006 13:14:20 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0291_01C674FC.D0A6C9D0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:3 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/134 X-Sequence-Number: 21666 This is a multi-part message in MIME format. ------=_NextPart_000_0291_01C674FC.D0A6C9D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi ... It's like trying to upload an image via FTP in ASCII format - it never = comes out the same the other end. Which one you are referring ?You mean If i load files using lo_import into DB and when i export it and see = the content is different right!!! But i read in postgres document as bytea is only for small files and not = ot store large contents.Am i right? I have already a table which stores all my image files as OID format?Is = there any alternative to do? Whether i need to store only image files in bytea format or all files = like(js,asp,htm etc) also.... Please explain me..It is very much needed for me.. Thank you, sandhya ----- Original Message -----=20 From: Andy Shellam=20 To: 'sandhya'=20 Cc: pgsql-admin@postgresql.org=20 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. =20 =20 -------------------------------------------------------------------------= ----- 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 =20 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) =20 Please help me in resolving this issue. Thanks in advance Regards, Sandhya =20 =20 !DSPAM:14,4462c7c434491454781929!=20 ------=_NextPart_000_0291_01C674FC.D0A6C9D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi=20 ...
It=92s like trying=20 to upload an image via FTP in ASCII format =96 it never comes out the = same the=20 other end.
Which one = you are=20 referring ?You mean
If i load = files using=20 lo_import into DB and when i export it and see  the content is=20 different right!!!
But i read in postgres = document as=20 bytea is only for small files and not ot store large contents.Am i=20 right?
 
I have already a table = which stores=20 all my image files as OID format?Is there any alternative to = do?
Whether i need to store = only image=20 files in bytea format or all files like(js,asp,htm etc) = also....
Please explain me..It = is very much=20 needed for me..
Thank you,
sandhya
 
 
----- Original Message -----
From:=20 Andy Shellam
Sent: Thursday, May 11, 2006 = 12:56=20 PM
Subject: RE: [ADMIN] regarding = image=20 files in DB

I would = think a data=20 type with the likes of =93binary=94 (bytea?) would be more = appropriate.  It=92s=20 like trying to upload an image via FTP in ASCII format =96 it never = comes out=20 the same the other end.

 

 


From: pgsql-admin-owner@postgr= esql.org=20 [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=20 DB

 

Hi,

   Please explain me is there any = difference=20 if i load my files(like gif or any images files) into the data = base as=20 text format?

Bcoz,I have loaded my image files in a text = format=20 into the database and when i exported it into my local file system the = content=20 of the original file(i.e. imported file into DB) and the exported = file=20 from the DB are different.

What is the wrong i did?In which format i = have to load=20 my file.Is it only for image files or for all types of files(like = js,asp,htm=20 etc)

 

Please help me in resolving this=20 issue.

Thanks in = advance

Regards,

Sandhya        =         =

 

!DSPAM:14,4462c7c434491454781929!=20

------=_NextPart_000_0291_01C674FC.D0A6C9D0--