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

From: Prabu Subroto <prabu_subroto(at)yahoo(dot)com>
To: Postgres General Milis <pgsql-general(at)postgresql(dot)org>
Subject: insertiing an image file (blob) into postres...
Date: 2004-09-01 11:52:51
Message-ID: 20040901115251.81807.qmail@web41803.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear my friends....

I created a column with datatype bytea. The name of
the column is emoicon

I did like this:

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
HINT: You will need to rewrite or cast the
expression.
kv=#

but comes error. What is my mistake?

Please tell me....

Thank you very much in advance.


__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Russ Brown 2004-09-01 11:54:45 Join efficiency
Previous Message Daniel Schuchardt 2004-09-01 08:51:24 Re: Exporting/moving Postgress Instance