From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | John McCawley <nospam(at)hardgeus(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Bytea to Text problems |
Date: | 2006-09-12 16:29:48 |
Message-ID: | 20060912162948.GF16069@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Caduto | 2006-09-12 16:40:25 | Re: Stored Procedure performance / elegance question |
Previous Message | rloefgren | 2006-09-12 16:27:55 | serial, sequence, and COPY FROM |