Thread: How to insert values in BYTEA?

How to insert values in BYTEA?

From
Oliver Nolden
Date:
Hi everyone,

I have a table with a bytea-column:

CREATE TABLE picture(
 id int primary key,
 preview bytea NOT NULL);

How can I insert a value in the bytea-column
'preview'? The function 'lo_import()' does only work
for oid. But what is about bytea?

If somebody has any suggestions or ideas, that would
be great.

Thanks a lot in advance,

Oliver






___________________________________________________________
Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de