On 6:01 pm 07/21/08 Jack Orenstein <[EMAIL PROTECTED]> wrote:
> to this:
> psql -h $SOURCE_HOST ... -c "copy binary $SOURCE_SCHEMA.$SOURCE_T
> ABLE to
> stdout" |\
> psql ... -c "copy binary $TARGET_SCHEMA.$TARGET_TABLE from stdin"
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html
Francisco Reyes wrote:
On 4:05 pm 07/21/08 Jack Orenstein <[EMAIL PROTECTED]> wrote:
What if we do a binary copy instead?
What do you mean by a binary copy?
pg_dump -Fc?
No, I mean changing this:
psql -h $SOURCE_HOST ... -c "copy $SOURCE_SCHEMA.$SOURCE_TABLE to stdout" |\
psql ...
On 4:05 pm 07/21/08 Jack Orenstein <[EMAIL PROTECTED]> wrote:
> We will now be adding 8.3.x databases to the mix, and will need to
> copy between 7.4.x and 8.3.x in both directions. The datatypes we use
I believe it should work.
Also, one feature I believe started in the 8.X line (8.2?), is the ab
We have a set of 7.4.x databases, and will occasionally copy data between like
so:
psql -h $SOURCE_HOST ... -c "copy $SOURCE_SCHEMA.$SOURCE_TABLE to stdout" |\
psql ... -c "copy $TARGET_SCHEMA.$TARGET_TABLE from stdin"
This is always run on the host containing the target table.
We will
