Re: Copy entire schema A to a different schema B

On 2/20/19 6:16 PM, Adrian Klaver wrote:
> On 2/20/19 2:22 PM, Tiffany Thang wrote:
>> Hi Adrian,
>> I managed to backup my table in parallel using -Fd but I'm back to my
>> original issue where I could not restore the table to a different schema.
>>
>> For example,
>> I would like to backup testuser1.mytable and restore it to
>> testuser2.mytable.
>>
>> pg_dump -U testuser1 -Fd -f c:\temp\testuser1 -j 8 -t mytable -h myserver
>> testdb
>
> Is table mytable big enough to actually need 8 parallel jobs?
>

A single table will only use a single thread, no matter how big it is, no? 
(That is my experience with v9.6, at least.)

--
Angular momentum makes the world go 'round.