Re: postgres sql assistance - Mailing list pgsql-general

From Jim Nasby
Subject Re: postgres sql assistance
Date
Msg-id b130385a-1ace-45d7-954c-dda7414ed7aa@gmail.com
Whole thread Raw
In response to Re: postgres sql assistance  (arun chirappurath <arunsnmimt@gmail.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Johnathan Tiamoh
Date:
Subject: Re: pg_basebackup Restore problem
Next
From: Jim Nasby
Date:
Subject: Re: Moving to Postgresql database