From sandhyar@amiindia.co.in Thu May 11 05:11:26 2006 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 8370C9FA32D for ; Thu, 11 May 2006 02:11:26 -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 08095-06 for ; Thu, 11 May 2006 02:11:16 -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 E86C19FA15C for ; Thu, 11 May 2006 02:11:10 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k4B54PAc014194 for ; Thu, 11 May 2006 10:34:31 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 43B8133266C; Thu, 11 May 2006 10:33:53 +0530 (IST) Message-ID: <007f01c674ba$5a862e40$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Cc: "sandhya" Subject: regarding image files in DB Date: Thu, 11 May 2006 10:48:35 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_007C_01C674E8.73F6D9F0" 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:1 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/128 X-Sequence-Number: 21660 This is a multi-part message in MIME format. ------=_NextPart_000_007C_01C674E8.73F6D9F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 =20 ------=_NextPart_000_007C_01C674E8.73F6D9F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
   Please explain me is there any = difference if i=20 load my files(like gif or any images files) into the data base as = text=20 format?
Bcoz,I have loaded my image files in a text format = into the=20 database and when i exported it into my local file system the content of = the=20 original file(i.e. imported file into DB) and the exported file = from the DB=20 are different.
What is the wrong i did?In which format i have to = load my=20 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 issue.
Thanks in advance
Regards,
Sandhya       =20        
 
------=_NextPart_000_007C_01C674E8.73F6D9F0-- From sandhyar@amiindia.co.in Thu May 11 07:04:46 2006 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 BD4D29FA32D for ; Thu, 11 May 2006 04:04: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 51397-04-2 for ; Thu, 11 May 2006 04:04:41 -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 6639A9FA15C for ; Thu, 11 May 2006 04:04:27 -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 k4B6vnxg006065 for ; Thu, 11 May 2006 12:27:50 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 392FB332680for ; Thu, 11 May 2006 12:27:49 +0530 (IST) Message-ID: <023601c674ca$45b196c0$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Subject: Regarding image files in DB Date: Thu, 11 May 2006 12:42:32 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0233_01C674F8.5F1FF880" 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:1 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/129 X-Sequence-Number: 21661 This is a multi-part message in MIME format. ------=_NextPart_000_0233_01C674F8.5F1FF880 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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) I installed postgresql8.0 .. Please help me in resolving this issue. Thanks in advance Regards, Sandhya =20 ------=_NextPart_000_0233_01C674F8.5F1FF880 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
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=20 format?
Bcoz,I have loaded my image files in a text format into the = database and=20 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=20 different.
What is the wrong i did?In which format i have to load my file.Is = it only=20 for image files or for all types of files(like js,asp,htm etc)
I installed postgresql8.0 ..
 
 
Please help me in resolving this issue.
Thanks in advance
Regards,
Sandhya   =20            
 
------=_NextPart_000_0233_01C674F8.5F1FF880-- From andy.shellam@mailnetwork.co.uk Thu May 11 07:26:55 2006 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 661C09FA29F for ; Thu, 11 May 2006 04:26:55 -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 60545-07 for ; Thu, 11 May 2006 04:26:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 10E249FA15C for ; Thu, 11 May 2006 04:26:45 -0300 (ADT) Received: from [213.146.143.243] (port=20864 helo=it020361) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1Fe5ZI-00077L-MO; Thu, 11 May 2006 08:26:40 +0100 Reply-To: From: "Andy Shellam" To: "'sandhya'" Cc: Subject: Re: regarding image files in DB Date: Thu, 11 May 2006 08:26:57 +0100 Organization: the mail network Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000B_01C674D4.AB164510" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 In-Reply-To: <007f01c674ba$5a862e40$cd00000a@sandhyar> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Thread-Index: AcZ0uYQPMx0bZomXSx6tKwqE1+A3BgAEnVVw X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/132 X-Sequence-Number: 21664 This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C674D4.AB164510 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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! ------=_NextPart_000_000B_01C674D4.AB164510 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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!

------=_NextPart_000_000B_01C674D4.AB164510-- From sandhyar@amiindia.co.in Thu May 11 07:36:46 2006 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-- From sandhyar@amiindia.co.in Thu May 11 07:38:00 2006 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 7FA139FA32D for ; Thu, 11 May 2006 04:38:00 -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 72145-04 for ; Thu, 11 May 2006 04:37:55 -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 6D1319FA29F for ; Thu, 11 May 2006 04:37:53 -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 k4B7VAAx013474; Thu, 11 May 2006 13:01:10 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 2EA2E33266C; Thu, 11 May 2006 13:01:10 +0530 (IST) Message-ID: <029d01c674ce$edb3daf0$cd00000a@sandhyar> From: "sandhya" To: Cc: References: Subject: Re: regarding image files in DB Date: Thu, 11 May 2006 13:15:52 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_029A_01C674FD.072E2390" 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/135 X-Sequence-Number: 21667 This is a multi-part message in MIME format. ------=_NextPart_000_029A_01C674FD.072E2390 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 -----=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_029A_01C674FD.072E2390 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Is there any document which explains clarly about = how to load=20 files in binart format and how to retrieve it....As far as i read i got = only=20 files storing in OID format.
Thanks for your help...
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_029A_01C674FD.072E2390--