How to insert values in bytea? - Mailing list pgsql-sql

From Oliver Nolden
Subject How to insert values in bytea?
Date
Msg-id 20040924153953.76946.qmail@web25301.mail.ukl.yahoo.com
Whole thread Raw
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] need ``row number``
Next
From: Greg Stark
Date:
Subject: Re: [GENERAL] need ``row number``