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 43B32D1B182 for ; Mon, 28 Jun 2004 01:51:58 -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 44810-09 for ; Mon, 28 Jun 2004 04:51:56 +0000 (GMT) Received: from mail.praemunio.com (mail.praemunio.com [66.179.47.216]) by svr1.postgresql.org (Postfix) with SMTP id 3D83AD1B174 for ; Mon, 28 Jun 2004 01:51:55 -0300 (ADT) Received: from localhost (HELO mail.knobbe.us) by localhost with SMTP; 27 Jun 2004 23:51:54 -0500 Received: from localhost (HELO ??) by localhost with SMTP; 27 Jun 2004 23:51:53 -0500 Subject: Re: Insert binary data on postgre From: Frank Knobbe To: "Eduardo S. Fontanetti" Cc: pgsql-admin@postgresql.org In-Reply-To: <20040625124309.92102.qmail@web40712.mail.yahoo.com> References: <20040625124309.92102.qmail@web40712.mail.yahoo.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-jAUGWf0MMnWHm8KPW7M3" Message-Id: <1088398310.1105.13.camel@localhost> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Sun, 27 Jun 2004 23:51:51 -0500 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/349 X-Sequence-Number: 14009 --=-jAUGWf0MMnWHm8KPW7M3 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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 --=-jAUGWf0MMnWHm8KPW7M3 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQBA36PmJjGc5ftAw8wRAgCeAJsFf/lJB5E71n6+uzR9u9gtfao6tACfemQZ lccNQTfiNcgJfRTbd6XVAfw= =wd5j -----END PGP SIGNATURE----- --=-jAUGWf0MMnWHm8KPW7M3--