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 ?