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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Biagioni | 2004-06-25 04:06:23 | Re: Insert binary data on postgre |
Previous Message | Eduardo S. Fontanetti | 2004-06-24 19:16:40 | Insert binary data on postgre |