From sandhyar@amiindia.co.in Thu Dec 15 08:37:25 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C7F0E9DC9D0 for ; Thu, 15 Dec 2005 04:37:25 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40044-04 for ; Thu, 15 Dec 2005 04:37:26 -0400 (AST) X-Greylist: delayed 03:05:06.71758 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id 8491F9DCAB5 for ; Thu, 15 Dec 2005 04:37:23 -0400 (AST) Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by svr2.postgresql.org (Postfix) with ESMTP id E857EF0B90 for ; Thu, 15 Dec 2005 05:32:08 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id jBF5S6IY032558 for ; Thu, 15 Dec 2005 10:58:06 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 6180D33276E; Thu, 15 Dec 2005 10:58:00 +0530 (IST) Message-ID: <00d101c60139$f357d0a0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" Subject: reg:Import&Export functions Date: Thu, 15 Dec 2005 11:09:43 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00CE_01C60168.0CF61C00" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:97.34721 C:21 M:1 S:5 R:5 X-imss-settings: Baseline:1 C:1 M:1 S:1 R:1 (0.0000 0.0000) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.002 required=5 tests=[AWL=-0.001, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.002 X-Spam-Level: X-Archive-Number: 200512/141 X-Sequence-Number: 19861 This is a multi-part message in MIME format. ------=_NextPart_000_00CE_01C60168.0CF61C00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, =20 I have my postgres server running on Linux OS. I need to export the files from the Linux OS to Windows drive. Is there any possibilty of doing this? I am connecting to DB through my VC 7Application. In that i need to export the files from the DB to the local machine = where i am running the application.Is it possible to do that? Please tell me what to do in that case.... Thank you Sandhya ------=_NextPart_000_00CE_01C60168.0CF61C00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi all,
 
I have my postgres server = running on Linux=20 OS.
I need to export the files from = the Linux=20 OS to Windows drive.
Is there any possibilty of = doing=20 this?
I am connecting to DB through my VC=20 7Application.
In that i need to export the files = from the DB=20 to the local machine where i am running the application.Is it possible = to do=20 that?
Please tell me what to do in that=20 case....
 
Thank you
Sandhya
------=_NextPart_000_00CE_01C60168.0CF61C00-- From bruno@wolff.to Fri Dec 16 04:18:35 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B41C69DC820 for ; Fri, 16 Dec 2005 00:18:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71246-06 for ; Fri, 16 Dec 2005 00:18:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 3DE259DC84B for ; Fri, 16 Dec 2005 00:18:32 -0400 (AST) Received: (qmail 32000 invoked by uid 500); 16 Dec 2005 04:23:37 -0000 Date: Thu, 15 Dec 2005 22:23:37 -0600 From: Bruno Wolff III To: sandhya Cc: postgre Subject: Re: reg:Import&Export functions Message-ID: <20051216042337.GA29958@wolff.to> Mail-Followup-To: Bruno Wolff III , sandhya , postgre References: <00d101c60139$f357d0a0$cd00000a@amiindiahjwbgh> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <00d101c60139$f357d0a0$cd00000a@amiindiahjwbgh> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.012 required=5 tests=[AWL=0.012] X-Spam-Score: 0.012 X-Spam-Level: X-Archive-Number: 200512/161 X-Sequence-Number: 19881 On Thu, Dec 15, 2005 at 11:09:43 +0530, sandhya wrote: > Hi all, > > I have my postgres server running on Linux OS. > I need to export the files from the Linux OS to Windows drive. > Is there any possibilty of doing this? Can you explain this in some more detail? Exporting files from linux to windows doesn't seem to have anything to do with Postgres. You would use samba to do that. > I am connecting to DB through my VC 7Application. > In that i need to export the files from the DB to the local machine where i am running the application.Is it possible to do that? > Please tell me what to do in that case.... > > Thank you > Sandhya From sandhyar@amiindia.co.in Fri Dec 16 05:07:48 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id F19D09DC820 for ; Fri, 16 Dec 2005 01:07:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 86093-10 for ; Fri, 16 Dec 2005 01:07:47 -0400 (AST) 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 C52249DC84B for ; Fri, 16 Dec 2005 01:07:37 -0400 (AST) 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 jBG52T2S018492; Fri, 16 Dec 2005 10:32:29 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 327F7332860; Fri, 16 Dec 2005 10:32:29 +0530 (IST) Message-ID: <003101c601ff$8d14d9c0$cd00000a@amiindiahjwbgh> From: "sandhya" To: "Bruno Wolff III" Cc: "postgre" References: <00d101c60139$f357d0a0$cd00000a@amiindiahjwbgh> <20051216042337.GA29958@wolff.to> Subject: Re: reg:Import&Export functions Date: Fri, 16 Dec 2005 10:44:11 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1441 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[AWL=0.000, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/162 X-Sequence-Number: 19882 hi..... Let me explain more about my problem........ I stored some of my files as largeobjects in Postgresql Database Through C-Program Using import functionality. My Postgres server is running on Linux OS. Now i want to export these objects through my application which is running on windows OS. Application uses VC7(.net).Here also i am using libpq library to export files from DB to the current application. I find that import and export can be used only inorder to store/retrieve files only in the UNIX filesystem path.Am i right? Actually i have connected from Windows OS to the remote server running on LinuxOS. Files are there(in LINUX OS) as large objects in the Postgres database. Now in my windows application i am using export function and mentioning the local host path..i.e.,windows path like C:\.Documents&settings\....etc..etc\home.htm But i am not find any "home.htm" in the mentioned path. If i want to get the files to the remote Client from the DB.What i should do? I need to change my function calls? Any permissions i need to set? And one more thing, In the Localhost(where the db server is running) I tried one sample which stores files (sample.txt)as objects in DB in one table.And to export it to the same host by giving some path(say tmp/sample.txt)..I am able to get the file in the mentioned location... The same .exe when i tried to execute through some other remoteclient(LINUX OS only) ....I am not able to get the file ...in the current local host.What may be the reason? But when i tried for INSERTING records through the same remote Client....it is inserting successfully in the database in the specified table. Why it is working in case of inserting records and why it is not working incase of files export from the same remote Client? Mail seems to be little confusing i think.....But i don't know how to explain my problem I can't proceed further without this..... Please explain me where i am doing mistake........... And tell me what to do?Thank you very much for your help...... -Sandhya ----- Original Message ----- From: "Bruno Wolff III" To: "sandhya" Cc: "postgre" Sent: Friday, December 16, 2005 9:53 AM Subject: Re: [ADMIN] reg:Import&Export functions > On Thu, Dec 15, 2005 at 11:09:43 +0530, > sandhya wrote: > > Hi all, > > > > I have my postgres server running on Linux OS. > > I need to export the files from the Linux OS to Windows drive. > > Is there any possibilty of doing this? > > Can you explain this in some more detail? Exporting files from linux to > windows doesn't seem to have anything to do with Postgres. You would > use samba to do that. > > > I am connecting to DB through my VC 7Application. > > In that i need to export the files from the DB to the local machine where i am running the application.Is it possible to do that? > > Please tell me what to do in that case.... > > > > Thank you > > Sandhya > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > From sandhyar@amiindia.co.in Fri Dec 16 08:10:46 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2810F9DC849 for ; Fri, 16 Dec 2005 04:10:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53781-07 for ; Fri, 16 Dec 2005 04:10:46 -0400 (AST) 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 7D4079DC807 for ; Fri, 16 Dec 2005 04:10:27 -0400 (AST) 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 jBG85EJv024543; Fri, 16 Dec 2005 13:35:14 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 25052332874; Fri, 16 Dec 2005 13:35:14 +0530 (IST) Message-ID: <013e01c60219$14c54b70$cd00000a@amiindiahjwbgh> From: "sandhya" To: "Bruno Wolff III" Cc: "postgre" References: <00d101c60139$f357d0a0$cd00000a@amiindiahjwbgh> <20051216042337.GA29958@wolff.to> Subject: Re: reg:Import&Export functions Date: Fri, 16 Dec 2005 13:46:56 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1441 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:21 M:2 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[AWL=0.000, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/163 X-Sequence-Number: 19883 hi..... I copied it using file streams.It worked fine for Linux even for the remote Client. But facing problems in Windows OS.I think it is not able to understand the OID that we are passing. It is giving error while opening the large object. In Windows application how can i pass the large objects. export(conn,objid,"c://home.htm"); Inside this function i am using lobj_fd = lo_open(conn, lobjId, INV_READ); if (lobj_fd < 0) { MessageBox(0,lobjId, "can't open large object",MB_OK); } It is displaying Can't open large object.......also it is not getting the value of "lobjId". I am new to postgres also this .net stuff.Pls help me to proceed further. Thank you Sandhya ----- Original Message ----- From: "Bruno Wolff III" To: "sandhya" Cc: "postgre" Sent: Friday, December 16, 2005 9:53 AM Subject: Re: [ADMIN] reg:Import&Export functions > On Thu, Dec 15, 2005 at 11:09:43 +0530, > sandhya wrote: > > Hi all, > > > > I have my postgres server running on Linux OS. > > I need to export the files from the Linux OS to Windows drive. > > Is there any possibilty of doing this? > > Can you explain this in some more detail? Exporting files from linux to > windows doesn't seem to have anything to do with Postgres. You would > use samba to do that. > > > I am connecting to DB through my VC 7Application. > > In that i need to export the files from the DB to the local machine where i am running the application.Is it possible to do that? > > Please tell me what to do in that case.... > > > > Thank you > > Sandhya > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >