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

Re: Insert binary data on postgre

From: mike g <mike(at)thegodshalls(dot)com>
To: "Eduardo S(dot) Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Insert binary data on postgre
Date: 2004-06-25 03:28:04
Message-ID: 1088134084.2640.7.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-admin
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
> 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 espao, anti-spam e antivrus grtis!
> http://br.info.mail.yahoo.com/
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html

In response to

Responses

pgsql-admin by date

Next:From: Andrew BiagioniDate: 2004-06-25 04:06:23
Subject: Re: Insert binary data on postgre
Previous:From: Eduardo S. FontanettiDate: 2004-06-24 19:16:40
Subject: Insert binary data on postgre

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