Re: insertiing an image file (blob) into postres... - Mailing list pgsql-general

Prabu Subroto schrieb:

> kv=# insert into salesreport (salesid, custid,
> emoicon) values('13', '4531',
> lo_import('/localhome/patrixlinux/arsip/proyek/qt/kv/client/images/1.png'));
> ERROR:  column "emoicon" is of type bytea but
> expression is of type oid

try to make a oid type column and repeat this.

CREATE TABLE test(
  ...
  emoicon    oid,
  ...
);

Daniel