Re: putting binary data in a char field? - Mailing list pgsql-general

From Ron Snyder
Subject Re: putting binary data in a char field?
Date
Msg-id D486606E7AD20947BDB7E56862E04C39474FAD@cvo1.cvo.roguewave.com
Whole thread Raw
In response to putting binary data in a char field?  (Ron Snyder <snyder@roguewave.com>)
List pgsql-general
> You should also experiment with using a TEXT field and base64
> encoding to insert data and base64 decoding to select data.
> In my experience, this is faster than using a bytea field.
> Certain characters in binary data have to be escaped properly
> before you can insert data.  The size and time this takes can
> vary.  Base64 encoding is fast and will increase the binary
> string by 1/3.

Hmm, I may give that a try.  Thanks,

-ron

pgsql-general by date:

Previous
From: tfo@alumni.brown.edu (Thomas F. O'Connell)
Date:
Subject: pg_dump out of shared memory
Next
From: Adam Smith
Date:
Subject: PostgresSQL 7.3.x removal