Re: Copying records from TABLE_A to TABLE_B (in the same database)

On 8/2/22 11:37 AM, Ron wrote:
> AWS RDS Postgresql 12.10
> 
> There are no indices or constraints (except for NOT NULL) on table_a.
> 
> The two ways that I know are:
>      INSERT INTO table_a SELECT * FROM table_b;
> and
>      \COPY table_a TO '/tmp/table_a.tsv' WITH (FORMAT BINARY);
>      \COPY table_b FROM '/tmp/table_a.tsv' WITH (FORMAT BINARY);
> 
> Is there a faster/better way?
> 
Does table_a have existing records?

If so do you care if there are duplicates?

How large a data set are you talking about?

-- 
Adrian Klaver
adrian.klaver@aklaver.com