Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C3EC1475CF3 for ; Thu, 22 Aug 2002 09:31:46 -0400 (EDT) Received: from ns.fotobank.ru (unknown [212.45.5.179]) by postgresql.org (Postfix) with ESMTP id 643D6475CBB for ; Thu, 22 Aug 2002 09:31:45 -0400 (EDT) Received: from jippy (gw.fotobank.ru [212.45.5.180]) by ns.fotobank.ru (8.11.6/8.11.6) with SMTP id g7MDVkU02863 for ; Thu, 22 Aug 2002 17:31:46 +0400 Message-ID: <000801c249e1$ecc025c0$3a00a8c0@jippy> From: "Klimov Andrew" To: Subject: bytea ,etc. Date: Thu, 22 Aug 2002 17:43:37 +0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0005_01C24A03.71B04550" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/411 X-Sequence-Number: 9257 This is a multi-part message in MIME format. ------=_NextPart_000_0005_01C24A03.71B04550 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Hi , All! Could someone clarify me : When I want to store BLOB's internally in database (for example jpeg ) should I use bytea or OID? Is OID something like BFILE in Oracle 8i? If both are appropriate why I can't use update image set picture=3Dlo_import('Myfile') where image_code=3D'blablabl= a'=20 with bytea column type but only with OID column type? And one more thing: Where is function byteain documented? TIA, Andrew. ------=_NextPart_000_0005_01C24A03.71B04550 Content-Type: text/html; charset="koi8-r" Content-Transfer-Encoding: quoted-printable
Hi , All!
 
Could someone clarify me  :
 
When I want to store BLOB's internally in = database=20 (for example jpeg )
should I use bytea or OID? Is OID somethin= g like=20 BFILE in Oracle 8i?
If both are appropriate why I can't=20 use
update image set picture=3Dlo_import('Myfi= le') where=20 image_code=3D'blablabla'
with bytea column type but only with OID c= olumn=20 type?
 
And one more thing:
Where is function byteain documented?
 
TIA,
Andrew.
------=_NextPart_000_0005_01C24A03.71B04550--