Skip site navigation (1) Skip section navigation (2)

Re: COPY FROM

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Bart Degryse <Bart(dot)Degryse(at)indicator(dot)be>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: COPY FROM
Date: 2006-02-09 15:27:08
Message-ID: 20060209152708.GB1178@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: 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

In response to

  • COPY FROM at 2006-02-08 10:03:55 from Bart Degryse

Responses

pgsql-odbc by date

Next:From: Tim ClarkeDate: 2006-02-09 15:34:56
Subject: Re: LATIN1/9 conversion....
Previous:From: Ludek FinstrleDate: 2006-02-09 15:21:02
Subject: Re: LATIN1/9 conversion....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group