bytea ,etc. - Mailing list pgsql-sql

From Klimov Andrew
Subject bytea ,etc.
Date
Msg-id 000801c249e1$ecc025c0$3a00a8c0@jippy
Whole thread Raw
List pgsql-sql
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=lo_import('Myfile') where image_code='blablabla'
with bytea column type but only with OID column type?
 
And one more thing:
Where is function byteain documented?
 
TIA,
Andrew.

pgsql-sql by date:

Previous
From: Kemin Zhou
Date:
Subject: trigger viewing
Next
From: "Philip Rudling"
Date:
Subject: sql statement to give functionality of \d tablename?