Yes, I've tried, but it is very slow to uuencode.
But I found another thing very better, the functions
lo_import and lo_export.
It solved my problem, really very good!!
Thanks a lot for all the help!
Eduardo
--- Frank Knobbe <[EMAIL PROTECTED]> escreveu: > On Fri,
2004-06-25 at 07:43, Eduardo
On Fri, 2004-06-25 at 07:43, 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 50 bytes, and this
> process is very, very and very slow. Then I need to
> use another way.
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 50 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 fu
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 50 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
I am using bytea data type and Visual Basic 6.
I saw in another place, that I can insert byte values
in the Postgre with a double backslash, then I used a
function to translate the binary string to ANSI
string. Then I can use: \\001\\010\\047 ...
Somebody could say me if its right?
Eduardo
---
Eduardo S. Fontanetti wrote:
How can I do to put a file into the PostgreSQL ? I
have got the contents of file in binary yet and put on
a String on my APP, but when I try to insert it on
postgre, it returns to me:
ERROR: parser: unterminated quoted string at or near
"BMæ»' at character 90
If you're
Eduardo,
your problem is the way you are submitting the string. Since it's a
binary, it can contain any "character" value (from 0 to 255) and
PostgreSQL treats certain characters as special characters. The main
example you're running into is the quote character.
If you try to submit a string
What data type did you use to define the binary column? bytea or LO?
On Thu, 2004-06-24 at 14:16, Eduardo S. Fontanetti wrote:
> How can I do to put a file into the PostgreSQL ? I
> have got the contents of file in binary yet and put on
> a String on my APP, but when I try to insert it on
> postg
How can I do to put a file into the PostgreSQL ? I
have got the contents of file in binary yet and put on
a String on my APP, but when I try to insert it on
postgre, it returns to me:
ERROR: parser: unterminated quoted string at or near
"BMæ»' at character 90
My string:
ConnP.Execute "insert in
