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

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Copying records from TABLE_A to TABLE_B (in the same database)
Date: 2022-08-02 18:41:00
Message-ID: 0f9d8171-7b10-2e3e-50a3-a4fa3fbfc0e2@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-08-02 18:41:24 Re: Copying records from TABLE_A to TABLE_B (in the same database)
Previous Message Ron 2022-08-02 18:37:38 Copying records from TABLE_A to TABLE_B (in the same database)