bytea ,etc.

From: "Klimov Andrew" <klimov(at)fotobank(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: bytea ,etc.
Date: 2002-08-22 13:43:37
Message-ID: 000801c249e1$ecc025c0$3a00a8c0@jippy
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-08-22 14:28:48 Re: Problem with timestamp field/time function.. (upgrading
Previous Message Andrew Klimov 2002-08-22 13:34:16 bytea etc.