Keith C. Perry wrote:
Quoting Tino Wildenhain <[EMAIL PROTECTED]>:
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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])