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

Поиск
Список
Период
Сортировка
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 по дате отправления: