скопировать из одной таблицы в несколько со вставкой ID

INSERT INTO MY_TABLE (ID, XXX, YYY) VALUES (111, 'xxx','yyy');

INSERT INTO student (surname, name, patronym, citizenship) 
(SELECT name1, name2, name3, country FROM import) RETURNING student_id 
INSERT INTO contract (contract_number, contract_date, payment, curriculum) 
(SELECT contract, datecontract, summcontract, spec FROM import) RETURNING contract_id INSERT INTO phone (student, calling_code, phone_number) (student_id) 
(SELECT code1, phone1 FROM import) INSERT INTO payment (payment_id, actual_amount_of_payment, date_of_pay) (contract_id) 
(SELECT summfact, datefact FROM import) 
INSERT INTO orders_admission (course_enrollment, department) (SELECT curs, fac FROM import) RETURNING order_admission_id 
INSERT INTO list_contract_student (student_id, contract_id) INSERT INTO list_student_in_admission (student_id, order_admission_id);

CREATE OR REPLACE FUNCTION insert_students() RETURNS VOID AS
$$
DECLARE
  stud RECORD;
   
  _id1 int;
  _id2 int;
  _id3 int;
BEGIN
  FOR stud IN (SELECT code1, phone1, code2, phone2, code3, phone3, name1, name2, name3, contract, datecontract, summcontract, summfactsem, summfact, datefact, spec, academic_program, qualification, curs, country, fac FROM import) 
  LOOP
    INSERT INTO student (surname, name, patronym, citizenship) VALUES (stud.name1, stud.name2, stud.name3, stud.country) RETURNING student_id INTO _id1;
    INSERT INTO contract (contract_number, contract_date, payment, curriculum) VALUES (stud.contract, stud.datecontract, stud.summcontract, stud.spec) RETURNING contract_id INTO _id2;
    INSERT INTO list_contract_student (lstudent_id, lcontract_id) VALUES (_id1, _id2);
    INSERT INTO orders_admission (course_enrollment, department) VALUES (stud.curs, stud.fac) RETURNING order_admission_id INTO _id3;
    INSERT INTO list_student_in_admission (student_id, order_admission_id) VALUES (_id1, _id3);
    INSERT INTO payment (payment_id, actual_amount_of_payment, date_of_pay) VALUES (_id2, stud.summfact, stud.datefact);
    IF stud.code1 IS NOT NULL THEN
    INSERT INTO phone (student, calling_code, phone_number) VALUES (_id1, stud.code1, stud.phone1);
    END IF;
    IF stud.code2 IS NOT NULL THEN
    INSERT INTO phone (student, calling_code, phone_number) VALUES (_id1, stud.code2, stud.phone2);
    END IF;
    IF stud.code3 IS NOT NULL THEN
    INSERT INTO phone (student, calling_code, phone_number) VALUES (_id1, stud.code3, stud.phone3);
    END IF;
    RAISE NOTICE 'вы вставили значение с id1 = %, id2 = % и id3 = %', _id1, _id2, _id3;
  END LOOP;
END
$$ LANGUAGE plpgsql;