Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group