Hello everyone,
Denis BUCHER a écrit :
> 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
> }
On Wed, Jul 22, 2009 at 08:24:22PM +0200, Denis BUCHER wrote:
> SELECT ... FROM ODBC source
> foreach row {
> INSERT INTO postgresql
> }
>
> The problem is that this method is very slow...
>
> Does someone has a better suggestion ?
Using COPY[1] is normally the preferred solution to getting data
Denis BUCHER wrote:
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 me
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...