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

Поиск
Список
Период
Сортировка
От Ron
Тема Copying records from TABLE_A to TABLE_B (in the same database)
Дата
Msg-id 5adcc923-889d-bb68-5a04-60125b6f0e96@gmail.com
обсуждение исходный текст
Ответы Re: Copying records from TABLE_A to TABLE_B (in the same database)  (Rob Sargent <robjsargent@gmail.com>)
Re: Copying records from TABLE_A to TABLE_B (in the same database)  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Copying records from TABLE_A to TABLE_B (in the same database)  (Thomas Kellerer <shammat@gmx.net>)
Список pgsql-general
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?

-- 
Angular momentum makes the world go 'round.



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

Предыдущее
От: jian he
Дата:
Сообщение: ICU is not supported in this build. install from source code.
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Copying records from TABLE_A to TABLE_B (in the same database)