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

Поиск
Список
Период
Сортировка
От Prabu Subroto
Тема insertiing an image file (blob) into postres...
Дата
Msg-id 20040901115251.81807.qmail@web41803.mail.yahoo.com
обсуждение исходный текст
Ответы Re: insertiing an image file (blob) into postres...  (Daniel Schuchardt <daniel_schuchardt@web.de>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Daniel Schuchardt
Дата:
Сообщение: Re: Exporting/moving Postgress Instance
Следующее
От: "Russ Brown"
Дата:
Сообщение: Join efficiency