Re: Insert binary data on postgre

From: Frank Knobbe <frank(at)knobbe(dot)us>
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-28 04:51:51
Message-ID: 1088398310.1105.13.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sebastian Böck 2004-06-28 05:50:42 Re: Is this a "Stupid Question" ?
Previous Message Tom Lane 2004-06-27 22:12:37 Re: Password with libpq