Andreas Pflug <[EMAIL PROTECTED]> writes: > Bruce Momjian wrote: > > > > For use case, consider this: > > > > COPY mytable TO '| rsh [EMAIL PROTECTED] > test '; > > > > so you can COPY to another server directly. > > > Why not rsh psql -c "\copy foobar to test" ?
Who knows? The sysadmin could have any reason to prefer one to the other. One that comes to mind is that he or she may want to automate this and may be happier granting password-free access to a filesystem server that just holds encrypted backups than to the live production database. -- greg ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly