Re: Help : insert a bytea data into new table

Quoth dennis <dennis@teltel.com>:
> 
>     I need to copy some data to new table.
> But I encounter some error message.
> the table structure
> Table A:
>   c1  char
>   c2  bytea
> 
> Table B:
>   c1  char
>   c2  bytea
> 
> 
> My sql command:
> insert into B as select * from a where c1=xxx

'AS' isn't valid there. What is xxx? Is it a field you haven't shown us,
or is it a quoted string?

> error:
> operator does not exist: text || bytea

That command (with 'xxx' quoted and the AS removed) doesn't give that
error with those table definitions, so you will need to show us your
actual query.

Ben