Re: restore multiple tables postgres

Thanks a lot.

On Wed, Apr 14, 2010 at 11:15 AM, Scott Mead
<scott(dot)lists(at)enterprisedb(dot)com>wrote:

>
> On Wed, Apr 14, 2010 at 11:03 AM, Scott Mead <scott(dot)lists(at)enterprisedb(dot)com
> > wrote:
>
>>
>> On Wed, Apr 14, 2010 at 10:56 AM, akp geek <akpgeek(at)gmail(dot)com> wrote:
>>
>>> Dear all -
>>>
>>> Can you please help me with this? Is there a way to restore
>>> multiples ( more than one table ) using a single command from a whole
>>> database dump that was created using pg_dump
>>>
>>>
> I just realized what you were asking, sorry... you were asking about
> multiple tables during restore. I thought that you could do:
>
> pg_restore -t <table> -t <table1>
> or
> pg_restore -t <table>,<table1>
>
> But it looks like you can't (just tried it with 8.4.2 pg_restore).
>
> Sorry for the mis-read.
>
> --Scott
>
>
>>
>> Depends on exactly how you took the pg_dump.
>>
>> Did you use -F c or -F t?
>>
>> --Scott
>>
>>
>>>
>>> regards
>>>
>>
>>
>