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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
