Skip site navigation (1) Skip section navigation (2)

Re: Use of the copy command

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Use of the copy command
Date: 2004-01-07 19:50:49
Message-ID: 3FFC6319.5000006@wildenhain.de (view raw or flat)
Thread:
Lists: pgadmin-support
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



In response to

pgadmin-support by date

Next:From: Keith C. PerryDate: 2004-01-07 20:00:22
Subject: Use of the copy command
Previous:From: Tino WildenhainDate: 2004-01-07 19:12:42
Subject: Re: Use of the copy command

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group