Re: Use of the copy command - Mailing list pgadmin-support

From Tino Wildenhain
Subject Re: Use of the copy command
Date
Msg-id 3FFC6319.5000006@wildenhain.de
Whole thread Raw
In response to Re: Use of the copy command  ("Keith C. Perry" <netadmin@vcsn.com>)
List pgadmin-support
Hi Keith,

Keith C. Perry wrote:
> Quoting Tino Wildenhain <tino@wildenhain.de>:
> 
> 
>>Hi Keith,
>>
>>Keith C. Perry wrote:
>>
>>>Does copy work in the SQL query editor on the pgadmin III snapshots (for
>>>windows).  When I try:
>>>
>>>copy from 'c:\test.txt'
>>>
>>>or
>>>
>>>copy to 'c:\test.txt'
>>>
>>>
>>>I get errors (e.g. "file not found" and "can not use relative pathname"
>>>respectively).  Thanks
>>>
>>
>>This has nothing to do with pgadmin. You are telling the
>>_server_ where to look for a file. I'm sure its not
>>running natively on a windows machine with this file in place.
>>
>>Regards
>>Tino Wildenhain
>>
> 
> 
> Yea, man i tried that like 5 seconds after sending my first email.  This how be
> however does lead me to ask is it possible to copy data relative to the client
> side?  This would be very useful as well.

psql (there is also a windows binary) makes this possible
via postgresqls/libpqs copy from stdin.
(Or rather write raw data to the socket in that case)
Someone would have to provide that piece of code for
pgadminIII as well. Should not be so hard while the
most work would be in the user-interface I guess.

Regards
Tino Wildenhain




pgadmin-support by date:

Previous
From: "Keith C. Perry"
Date:
Subject: Re: Use of the copy command
Next
From: Richard van den Berg
Date:
Subject: Refreshing removed object crashes pgadmin3