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 >>The BINARY key word causes all data to be stored/read as binary format >>rather than as text. It is somewhat faster than the normal text mode, but a >>binary-format file is less portable across machine architectures and >>PostgreSQL versions.<< I would suggest to not go that route. However, you could just test it and see if it works. If you are doing multiple tables I still think you should consider pg_dump -Fc. You can restore just the data without the DDL. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
