X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 864D2329C70
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 24 Sep 2004 16:40:04 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 10108-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 24 Sep 2004 15:39:55 +0000 (GMT)
Received: from web25301.mail.ukl.yahoo.com (web25301.mail.ukl.yahoo.com
	[217.12.10.73])
	by svr1.postgresql.org (Postfix) with SMTP id 3A93F329C6B
	for <pgsql-sql@postgresql.org>; Fri, 24 Sep 2004 16:39:54 +0100 (BST)
Message-ID: <20040924153953.76946.qmail@web25301.mail.ukl.yahoo.com>
Received: from [193.174.50.2] by web25301.mail.ukl.yahoo.com via HTTP;
	Fri, 24 Sep 2004 17:39:53 CEST
Date: Fri, 24 Sep 2004 17:39:53 +0200 (CEST)
From: Oliver Nolden <oliver_nol@yahoo.de>
Subject: How to insert values in bytea?
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200409/217
X-Sequence-Number: 19063

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