Re: dump-restore only one table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Kuprijanov <sanya-spb(at)list(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dump-restore only one table
Date: 2007-05-01 14:43:37
Message-ID: 17089.1178030617@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Kuprijanov <sanya-spb(at)list(dot)ru> 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
> ====================================

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?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2007-05-01 14:48:02 Re: IF function?
Previous Message Alban Hertroys 2007-05-01 14:43:15 Re: Processing a work queue