Alexander Kuprijanov wrote:
I do: ==============pg_dump -d BaseA --port=54321 --host=localhost --table=TableA --data-only -F c -v | pg_restore -d BaseB --data-only --no-owner --table=TableA --single-transaction -v==============
But <BaseB.TableA> wasn't updated.... why??
I'm not sure you can pipe the custom format between pg_dump and pg_restore (it's got compressed sections). Either:
1. Use a temporary file 2. pipe the standard format to psql -- Richard Huxton Archonet Ltd
