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 47641D1B199 for ; Fri, 25 Jun 2004 06:08:28 -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 80000-04 for ; Fri, 25 Jun 2004 09:08:28 +0000 (GMT) Received: from mxc.pcnet.ro (unknown [82.137.14.5]) by svr1.postgresql.org (Postfix) with ESMTP id A6251D1B173 for ; Fri, 25 Jun 2004 06:08:24 -0300 (ADT) Received: from aldratech.com (aldratech.com.pcnet.ro [213.154.158.58] (may be forged)) by mxc.pcnet.ro (8.12.10/8.12.10) with ESMTP id i5P98Ng2030609 for ; Fri, 25 Jun 2004 12:08:24 +0300 Received: from aldratech.com ([192.168.0.6]) by aldratech.com for with eXtremail; Fri, 25 Jun 2004 12:08:24 +3GMT Message-ID: <40DBEC24.9030406@aldratech.com> Date: Fri, 25 Jun 2004 12:11:00 +0300 From: Radu-Adrian Popescu Reply-To: radu.popescu@aldratech.com Organization: Aldratech Ltd. User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.6) Gecko/20040510 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Eduardo S. Fontanetti" Cc: pgsql-admin@postgresql.org Subject: Re: Insert binary data on postgre References: <20040624191640.84897.qmail@web40707.mail.yahoo.com> In-Reply-To: <20040624191640.84897.qmail@web40707.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/331 X-Sequence-Number: 13991 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 using Java, check out http://doc.postgresintl.com/jdbc/ch08.html Cheers, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243