Re: gsoc ideas - Mailing list pgsql-general

From longlong
Subject Re: gsoc ideas
Date
Msg-id d9f0a46b0803110355k1a5eee9dlcef018d2ea049711@mail.gmail.com
Whole thread Raw
In response to Re: gsoc ideas  (Richard Huxton <dev@archonet.com>)
List pgsql-general
i see.
now i know that COPY with STDIN/OUT can do what i mentioned before exactly.

 
2008/3/11, Richard Huxton <dev@archonet.com>:
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

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: split pg_dumpall backups per database
Next
From: Sam Mason
Date:
Subject: Re: ISO something like "#if 0 ... #endif" for SQL code