Re: Use of the copy command

Hi Keith,

Keith C. Perry wrote:
> Quoting Tino Wildenhain <tino(at)wildenhain(dot)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