Eduardo S. Fontanetti wrote:
> I forgot a little, or better, a big detail, to do this
> translating from binary to ANSI of a file with 100Kb,
> it will return something like 500000 bytes, and this
> process is very, very and very slow. Then I need to
> use another way.
> I've tried to use the Replace native function from the
> VB to put a backslash before the ' on the string, but
> it hadn't worked, I think it don't interprets the
> character like postgres. Somebody knows how to solve
> it? How to identify the character exactly like the
The escape functions are located in the libpq library (PostgreSQL's native C
library), that has a Windows native port.
You may either look at the code and implement that in VB (don't think it will
perform very well though) or write a COM wrapper or something like that to make
those functions available in VB.
Best of luck,
CSA, DBA, Developer
In response to
pgsql-admin by date
|Next:||From: Carlos Benkendorf||Date: 2004-06-25 16:17:30|
|Subject: SQL preprocessor output|
|Previous:||From: Eduardo S. Fontanetti||Date: 2004-06-25 12:43:09|
|Subject: Re: Insert binary data on postgre|