Re: dump-restore only one table - Mailing list pgsql-general

From Tom Lane
Subject Re: dump-restore only one table
Date
Msg-id 17887.1178035375@sss.pgh.pa.us
Whole thread Raw
In response to Re: dump-restore only one table  (Alexander Kuprijanov <sanya-spb@list.ru>)
Responses Re: dump-restore only one table
List pgsql-general
Alexander Kuprijanov <sanya-spb@list.ru> 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 small-case letter

Hmph.  I tried to reproduce your problem here (even to the extent of
using 8.2 pg_dump to dump from an 8.1 database) but it works fine as
far as I can tell.  If you leave off the --table option to pg_restore
does it restore the data?  Can you put together a complete test-case
to make it fail for someone else?

            regards, tom lane

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: IF function?
Next
From: Alban Hertroys
Date:
Subject: Re: Processing a work queue