On Wed, Mar 21, 2012 at 2:56 PM, Alexander Reichstadt <l...@mac.com> wrote:

> Hi,
>
> when trying to change a text column to bytea I am getting the following
> error:
>
> *SQL error:*
>
> ERROR:  column "comment" cannot be cast to type bytea
>
>
> *In statement:*
> ALTER TABLE "public"."persons" ALTER COLUMN "comment" TYPE bytea
>

TRY ALTER TYPE ...USING using either direct cast or encode() function.

Please don't post emails in HTML format, thanks!

merlin

Reply via email to