bytea etc. - Mailing list pgsql-sql

From Andrew Klimov
Subject bytea etc.
Date
Msg-id 20020822133416.86495.qmail@web20417.mail.yahoo.com
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 for internal BLOB 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.



Do You Yahoo!?
HotJobs, a Yahoo! service - Search Thousands of New Jobs

pgsql-sql by date:

Previous
From: Lucas Brasilino
Date:
Subject: Re: Problem with timestamp field/time function.. (upgrading
Next
From: Stephan Szabo
Date:
Subject: Re: Problem with timestamp field/time function.. (upgrading