Re: pg_restore -t table concerns - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_restore -t table concerns
Date
Msg-id 4A48FAD3.9090807@dunslane.net
Whole thread Raw
In response to Re: pg_restore -t table concerns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

Tom Lane wrote:
> Mike Toews <mwtoews@sfu.ca> writes:
>   
>> I have a few concerns with the usability and documentation for 
>> pg_restore (note: I'm on 8.3, but I've checked the documentation for 8.4).
>>     
>
> There's a TODO item about that already...
>
> * Add support for multiple pg_restore -t options, like pg_dump
>
>     pg_restore's -t switch is less useful than pg_dump's in quite a
>     few ways: no multiple switches, no pattern matching, no ability
>     to pick up indexes and other dependent items for a selected
>     table. It should be made to handle this switch just like pg_dump
>     does.
>
>             
>   

It should also be pointed out that there is a workaround using the 
--use-list option.

cheers

andrew


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pre-proposal: permissions made easier
Next
From: Josh Berkus
Date:
Subject: Re: pre-proposal: permissions made easier