Insert From Dynamic Query In Postgres

With reference solution I've posted in my previous post resulted in one more situation. While trying to insert into my destination table(schema as below). -- Table: normalized_tra

Solution 1:

You could try like so:

INSERT INTO normalized_transaction(account_number, currency, trade_date)
SELECT foo.*
FROM gen_Test('english') as foo;