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

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Copying records from TABLE_A to TABLE_B (in the same database)
Дата
Msg-id 0f9d8171-7b10-2e3e-50a3-a4fa3fbfc0e2@gmail.com
обсуждение исходный текст
Ответ на Copying records from TABLE_A to TABLE_B (in the same database)  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Copying records from TABLE_A to TABLE_B (in the same database)  (Ron <ronljohnsonjr@gmail.com>)
Список 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 ?

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Copying records from TABLE_A to TABLE_B (in the same database)
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Copying records from TABLE_A to TABLE_B (in the same database)