On Tue, Sep 12, 2006 at 10:56:09AM -0500, John McCawley wrote: > I've searched high and low, and all I've found is people being chided > for trying to convert from Bytea to text :) > > When I first designed my database, I simply didn't understand the > purpose of bytea, I didn't actually realize that there *was* a text data > type. (Actually, I was porting from a MS SQL database, and if I > remember correctly, PgAdmin actually made the decision for me) I now > need to convert my field from bytea to text, but there doesn't seem to > be a clean way to do it. So far I have done the following:
Doesn't straight assignment do it? Don't confuse the escaped output from bytea with the actual data. Hope this helps, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
