INSERT INTO — existing — TABLE

Laut Doku könnte folgendes funktionieren:

SELECT uuid_generate_v4(),
       doc_order_uuid,
       doc_order_filename,
       doc_order_price,
       doc_order_tax,
       user_uuid_create
INTO TABLE doc_order_send
FROM doc_order;

…es wirft aber den Fehler: [42P07] ERROR: relation "doc_order_send" already exists

Funktionieren tut folgendes:

INSERT INTO doc_order_send
SELECT uuid_generate_v4(),
       doc_order_uuid,
       doc_order_filename,
       doc_order_price,
       doc_order_tax,
       user_uuid_create
FROM doc_order;