performant import of an array

From: "Janek Sendrowski" <janek12(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: performant import of an array
Date: 2013-08-23 21:19:59
Message-ID: trinity-64c3a52d-2d46-44a9-a4b0-13d2c22f59d8-1377292799682@3capp-webde-bs16
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have an array and I want to import the data rowwise.

Would it make sense to use a function which calls a prepared statement in a loop to import the data performant?

Or can I somehow use the COPY FROM command?
 
Janek Sendrowski

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-08-23 21:23:36 Re: performant import of an array
Previous Message Hall, Samuel L (Sam) 2013-08-23 15:13:02 Re: Update quey