Re: [GENERAL] performant import of an array

2013-08-23 Thread Pavel Stehule
Hello import data to auxiliary table, and then use a ARRAY(subselect) or array_agg function to transformation from table to array. Regards Pavel 2013/8/23 Janek Sendrowski > Hi, > > I have an array and I want to import the data rowwise. > > Would it make sense to use a function which calls a

[GENERAL] performant import of an array

2013-08-23 Thread Janek Sendrowski
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 -- Sent via pgsql-general mailing list (pgsql-general@post