How to transfer data from one schema to another after Postgresql normalization?

Question

PostgreSQL

Is there any ready-made software that allows you to transfer data from one schema to another.
In one scheme, the data is entered into PostgreSQL. In the other they are stored in a normalized form. You will often need to transfer data. Therefore, you need a utility that will do this with the click of a button, or you need a function on Postgresql (I don’t know functions in Postgresql well). It's easier to write in delphi.
But on delphi to produce the same code. Too long. Normalized tables 34

Answer 1

um... what's the problem?

INSERT INTO normalized.table1
SELECT * FROM public.table1

Answer 2

What if the data is already in the table?
In addition, the operation must be performed quite often.
Unnormalized tables receive data periodically.
It is inexpedient to write many inserts every time.
Is there an example of a stored function that only does an Insert? Many inserts in one function (same as in the example above).