Skip site navigation (1) Skip section navigation (2)

How to insert values in bytea?

From: Oliver Nolden <oliver_nol(at)yahoo(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to insert values in bytea?
Date: 2004-09-24 15:39:53
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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,



Gesendet von Yahoo! Mail - Jetzt mit 100MB Speicher kostenlos - Hier anmelden:

pgsql-sql by date

Next:From: Greg StarkDate: 2004-09-24 20:34:47
Subject: Re: [SQL] need ``row number``
Previous:From: Vladimir S. TikhonjukDate: 2004-09-24 14:21:48
Subject: INDEX problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group