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