i see.
now i know that COPY with STDIN/OUT can do what i mentioned before exactly.
2008/3/11, Richard Huxton <dev@xxxxxxxxxxxx>:
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"
--
Richard Huxton
Archonet Ltd
