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

[Rob Sargent <robjsargent@xxxxxxxxx>]

On 8/2/22 12:37, 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?
>       
>       
>     
    create view ?