pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: sandhya <sandhyar@amiindia.co.in>
To: Bruno Wolff III <bruno@wolff.to>
Cc: postgre <pgsql-admin@postgresql.org>
Subject: Re: reg:Import&Export functions
Date: Fri, 16 Dec 2005 10:44:11 +0530
Message-ID: <003101c601ff$8d14d9c0$cd00000a@amiindiahjwbgh> (raw)
References: <00d101c60139$f357d0a0$cd00000a@amiindiahjwbgh>
	<20051216042337.GA29958@wolff.to>

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" <bruno@wolff.to>
To: "sandhya" <sandhyar@amiindia.co.in>
Cc: "postgre" <pgsql-admin@postgresql.org>
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 <sandhyar@amiindia.co.in> 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
>





view thread (4+ messages)  latest in thread

Message-ID: <003101c601ff$8d14d9c0$cd00000a@amiindiahjwbgh>
Permalink:  ../003101c601ff$8d14d9c0$cd00000a@amiindiahjwbgh/
Also on:    postgresql.org/message-id/003101c601ff$8d14d9c0$cd00000a@amiindiahjwbgh

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: sandhyar@amiindia.co.in, bruno@wolff.to
  Subject: Re: reg:Import&Export functions
  In-Reply-To: <003101c601ff$8d14d9c0$cd00000a@amiindiahjwbgh>
  References: <00d101c60139$f357d0a0$cd00000a@amiindiahjwbgh> <20051216042337.GA29958@wolff.to> <003101c601ff$8d14d9c0$cd00000a@amiindiahjwbgh>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox