Alexander Kuprijanov <[EMAIL PROTECTED]> writes:
> % pg_dump -d test_a --table=b -F c -v -f b.backup
That syntax doesn't actually work in any reasonably modern version
of pg_dump ... what are you really typing? (-d is not a switch for
specifying the database name.)
But at any rate, I still can't
On Tuesday 01 May 2007 20:02:55 Tom Lane wrote:
> Alexander Kuprijanov <[EMAIL PROTECTED]> writes:
> > On Tuesday 01 May 2007 18:43:37 Tom Lane wrote:
> >> Works for me. Perhaps your table name is mixed-case and you didn't
> >> quote it correctly? Have you tried 'pg_restore -l' to verify what
> >
Alexander Kuprijanov <[EMAIL PROTECTED]> writes:
> On Tuesday 01 May 2007 18:43:37 Tom Lane wrote:
>> Works for me. Perhaps your table name is mixed-case and you didn't
>> quote it correctly? Have you tried 'pg_restore -l' to verify what
>> is in the dump file?
> no, tablenames not mixed, all s
On Tuesday 01 May 2007 18:43:37 Tom Lane wrote:
> Alexander Kuprijanov <[EMAIL PROTECTED]> writes:
> > but pg_restore dont want make its work...
> >
> > % pg_restore --dbname=BaseB --no-owner --table=TableA -v
> > ./idstation.backup pg_restore: connecting to dat
Alexander Kuprijanov <[EMAIL PROTECTED]> writes:
> but pg_restore dont want make its work...
>
> % pg_restore --dbname=BaseB --no-owner --table=TableA -v ./idstation.backup
> pg_restore: connecting to database for restore
> pg_restore: implied data-only restore
On Tuesday 01 May 2007 14:41:38 Richard Huxton wrote:
> 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
> >
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 wasn't updated why??
I'm not sure you can pipe the
