Re: Best way to import data in postgresl (not "COPY")

You could group the insert into batches using:

INSERT INTO table (field1, field2)
Select value1, value2
Union all Select value1, value2
Union all Select value1, value2
Union all Select value1, value2
Union all Select value1, value2
Union all Select value1, value2;

> -----Original Message-----
> From: pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Denis BUCHER
> Sent: Wednesday, July 22, 2009 11:31 AM
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Best way to import data in postgresl (not "COPY")
>
>
> Hello,
>
> I have a system that must each day import lots of data from
> another one. Our system is in postgresql and we connect to
> the other via ODBC.
>
> Currently we do something like :
>
> SELECT ... FROM ODBC source
> foreach row {
> INSERT INTO postgresql
> }
>
> The problem is that this method is very slow...
>
> More especially that for each row we do :
> field1 = ...
> field2 = ...
> And then
> $sql_insert = "INSERT ..." . field1 ....
>
>
> Does someone has a better suggestion ?
>
> Thanks a lot in advance !
>
> Denis
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>