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

Insert binary data on postgre

From: Eduardo S(dot) Fontanetti <dufuzzy(at)yahoo(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Insert binary data on postgre
Date: 2004-06-24 19:16:40
Message-ID: 20040624191640.84897.qmail@web40707.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
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 into fotossocios(arquivo)
values('" & Conteudo & "')"

Could somebody help me how to construct the right
string ?

Thanks
Eduardo

______________________________________________________________________

Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis!
http://br.info.mail.yahoo.com/

Responses

pgsql-admin by date

Next:From: mike gDate: 2004-06-25 03:28:04
Subject: Re: Insert binary data on postgre
Previous:From: Bruno Wolff IIIDate: 2004-06-24 17:56:57
Subject: Re: How can I backup database from database itself

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