i see. now i know that COPY with STDIN/OUT can do what i mentioned before exactly.
2008/3/11, Richard Huxton <[EMAIL PROTECTED]>: > > 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 >
