longlong wrote: > your words are a great encouragement to me! > > i am embarrassed by my English and i will improve it. > > maybe i missed something that makes you a little misunderstand in point 3. > what i want is data-copys between databases automatically processed by > program. and databases may be not in the same host. i feel that this is hard > to implement now. so i'll try 1 and 2 in [HACKERS].
You can do it with different hosts too:
psql -h host1 -c "copy x to stdout" | psql -h host2 -c "copy y from stdin"