pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedreg:Import&Export functions
4+ messages / 2 participants
[nested] [flat]
* reg:Import&Export functions
@ 2005-12-15 05:39 sandhya <sandhyar@amiindia.co.in>
2005-12-16 04:23 ` Re: reg:Import&Export functions Bruno Wolff III <bruno@wolff.to>
0 siblings, 1 reply; 4+ messages in thread
From: sandhya @ 2005-12-15 05:39 UTC (permalink / raw)
To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>
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?
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: reg:Import&Export functions
2005-12-15 05:39 reg:Import&Export functions sandhya <sandhyar@amiindia.co.in>
@ 2005-12-16 04:23 ` Bruno Wolff III <bruno@wolff.to>
2005-12-16 05:14 ` Re: reg:Import&Export functions sandhya <sandhyar@amiindia.co.in>
2005-12-16 08:16 ` Re: reg:Import&Export functions sandhya <sandhyar@amiindia.co.in>
0 siblings, 2 replies; 4+ messages in thread
From: Bruno Wolff III @ 2005-12-16 04:23 UTC (permalink / raw)
To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: reg:Import&Export functions
2005-12-15 05:39 reg:Import&Export functions sandhya <sandhyar@amiindia.co.in>
2005-12-16 04:23 ` Re: reg:Import&Export functions Bruno Wolff III <bruno@wolff.to>
@ 2005-12-16 05:14 ` sandhya <sandhyar@amiindia.co.in>
1 sibling, 0 replies; 4+ messages in thread
From: sandhya @ 2005-12-16 05:14 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: reg:Import&Export functions
2005-12-15 05:39 reg:Import&Export functions sandhya <sandhyar@amiindia.co.in>
2005-12-16 04:23 ` Re: reg:Import&Export functions Bruno Wolff III <bruno@wolff.to>
@ 2005-12-16 08:16 ` sandhya <sandhyar@amiindia.co.in>
1 sibling, 0 replies; 4+ messages in thread
From: sandhya @ 2005-12-16 08:16 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: pgsql-admin
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" <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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-12-16 08:16 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-15 05:39 reg:Import&Export functions sandhya <sandhyar@amiindia.co.in>
2005-12-16 04:23 ` Bruno Wolff III <bruno@wolff.to>
2005-12-16 05:14 ` sandhya <sandhyar@amiindia.co.in>
2005-12-16 08:16 ` sandhya <sandhyar@amiindia.co.in>
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