How to insert values in BYTEA?

From: Oliver Nolden <oliver_nol(at)yahoo(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: How to insert values in BYTEA?
Date: 2004-09-24 15:37:19
Message-ID: 20040924153719.76590.qmail@web25306.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message David Helgason 2004-09-24 15:39:24 Re: Large arrays give long lag on server side before command executes
Previous Message Amin Abdulghani 2004-09-24 15:20:49 Removed and then missing pg_clog file