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