On 1/16/24 10:04 PM, arun chirappurath wrote:
Architect is pressing for a native procedure to data load.
It's possible to write a loader in pl/pgsql but it would be easily twice as complex as where you got on your first attempt. It would also never perform anywhere near as well as a dedicated loader, because there's no way to avoid the temp table (which a native loader doesn't need to use).
-- Jim Nasby, Data Architect, Austin TX
