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 075B1D1B26D for ; Mon, 28 Jun 2004 10:50:27 -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 73714-07 for ; Mon, 28 Jun 2004 13:50:27 +0000 (GMT) Received: from web40711.mail.yahoo.com (web40711.mail.yahoo.com [66.218.78.168]) by svr1.postgresql.org (Postfix) with SMTP id 40F79D1B241 for ; Mon, 28 Jun 2004 10:50:22 -0300 (ADT) Message-ID: <20040628135024.57625.qmail@web40711.mail.yahoo.com> Received: from [200.163.192.124] by web40711.mail.yahoo.com via HTTP; Mon, 28 Jun 2004 10:50:24 ART Date: Mon, 28 Jun 2004 10:50:24 -0300 (ART) From: "=?iso-8859-1?q?Eduardo=20S.=20Fontanetti?=" Subject: Re: Insert binary data on postgre To: pgsql-admin@postgresql.org In-Reply-To: <1088398310.1105.13.camel@localhost> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=4.6 tagged_above=0.0 required=5.0 tests=RCVD_IN_DSBL, RCVD_IN_NJABL, RCVD_IN_NJABL_PROXY, RCVD_IN_SORBS, RCVD_IN_SORBS_HTTP, RCVD_IN_SORBS_SOCKS X-Spam-Level: **** X-Archive-Number: 200406/350 X-Sequence-Number: 14010 Yes, I've tried, but it is very slow to uuencode. But I found another thing very better, the functions lo_import and lo_export. It solved my problem, really very good!! Thanks a lot for all the help! Eduardo --- Frank Knobbe escreveu: > On Fri, 2004-06-25 at 07:43, Eduardo S. Fontanetti > wrote: > > I forgot a little, or better, a big detail, to do > this > > translating from binary to ANSI of a file with > 100Kb, > > it will return something like 500000 bytes, and > this > > process is very, very and very slow. Then I need > to > > use another way. > > Have you considered uuencoding or binhexing the data > so that you end up > with a "clean" string you can commit? (It will still > suck up twice the > file size in space though). > > Regards, > Frank > > > ATTACHMENT part 2 application/pgp-signature name=signature.asc ______________________________________________________________________ Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis! http://br.info.mail.yahoo.com/