Re: COPY FROM - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: COPY FROM
Date
Msg-id 20060209152708.GB1178@soptik.pzkagis.cz
Whole thread Raw
In response to COPY FROM  ("Bart Degryse" <Bart.Degryse@indicator.be>)
List pgsql-odbc
> In the driver logging I can see that it's waiting for the data now,
> but I can't really figure out how to deliver it. Since the source
> data (as a text file with fixed length fields) is only available
> on client side and needs some processing before being ready to import

I think ODBC doesn't support something like standard input ...
Or maybe it does? Do you try print the prepared data to the standard
output?

> So basically my question is : how do I deliver the prepared data
> to the driver? Any help (tips, working code, example, ...)
> would be appreciated.

If you can't find the way you can try to use insert statements.
You may collect multiple insert statements into one transaction
to speed up the data loading.

Regards,

Luf

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: LATIN1/9 conversion....
Next
From: "Tim Clarke"
Date:
Subject: Re: LATIN1/9 conversion....