Re: insertiing an image file (blob) into postres...

From: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: insertiing an image file (blob) into postres...
Date: 2004-09-01 17:59:30
Message-ID: ch52m0$1kug$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Nolan 2004-09-01 18:11:45 beta2 not finding openssl
Previous Message Marc G. Fournier 2004-09-01 17:50:59 Re: PostgreSQL 8.0.0 Beta 2 Uploaded