X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 639C6D1B380 for ; Fri, 25 Jun 2004 00:28:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53045-08 for ; Fri, 25 Jun 2004 03:28:41 +0000 (GMT) Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.198.35]) by svr1.postgresql.org (Postfix) with ESMTP id 8417BD1B366 for ; Fri, 25 Jun 2004 00:28:40 -0300 (ADT) Received: from localhost.localdomain (c-67-162-89-61.client.comcast.net[67.162.89.61]) by comcast.net (rwcrmhc11) with ESMTP id <2004062503283901300f0143e>; Fri, 25 Jun 2004 03:28:40 +0000 Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.12.11/8.12.11) with ESMTP id i5P3S4oZ002680; Thu, 24 Jun 2004 22:28:05 -0500 Received: (from spike@localhost) by localhost.localdomain (8.12.11/8.12.11/Submit) id i5P3S4XE002677; Thu, 24 Jun 2004 22:28:04 -0500 X-Authentication-Warning: localhost.localdomain: spike set sender to mike@thegodshalls.com using -f Subject: Re: Insert binary data on postgre From: mike g Reply-To: mike@thegodshalls.com To: "Eduardo S. Fontanetti" Cc: pgsql-admin@postgresql.org In-Reply-To: <20040624191640.84897.qmail@web40707.mail.yahoo.com> References: <20040624191640.84897.qmail@web40707.mail.yahoo.com> Content-Type: text/plain; charset= Content-Transfer-Encoding: quoted-printable Message-Id: <1088134084.2640.7.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Thu, 24 Jun 2004 22:28:04 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200406/329 X-Sequence-Number: 13989 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: >=20 > ERROR: parser: unterminated quoted string at or near > "BM=C3=A6=C2=BB=01' at character 90 >=20 > My string: >=20 > ConnP.Execute "insert into fotossocios(arquivo) > values('" & Conteudo & "')" >=20 > Could somebody help me how to construct the right > string ? >=20 > Thanks > Eduardo >=20 > ______________________________________________________________________ >=20 > Yahoo! Mail - agora com 100MB de espa=C3=A7o, anti-spam e antiv=C3=ADrus = gr=C3=A1tis! > http://br.info.mail.yahoo.com/ >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? >=20 > http://www.postgresql.org/docs/faqs/FAQ.html