Re: dump-restore only one table

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