Re: Supporting SQL/MED DATALINK - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Supporting SQL/MED DATALINK
Date
Msg-id CAF-3MvN36oWPObs5WfikuT=psDnm13Zd4ueRJ8=hr0ccgnKLYQ@mail.gmail.com
Whole thread Raw
In response to Re: Supporting SQL/MED DATALINK  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On 9 January 2012 12:36, John R Pierce <pierce@hogranch.com> wrote:
> On 01/09/12 3:07 AM, Alban Hertroys wrote:
>>>
>>> For the record, it looks like MS SQL Server has some equivalent feature :
>>> >  FILESTREAM.
>>
>> And Oracle has BFILE.
>
> aren't these things functionally similar to PG's LO (large object) ?

Oracle has BLOBs and CLOBs as well. IIRC, BFILEs reference a file on
the file-system, while [BC]LOBs are stored inside the database in some
way.

Admittedly, the last time I worked with an Oracle database is 10 years
ago. Things may have changed, or my memory of them may have ;)

--
If you can't see the forest for the trees,
Cut the trees and you'll find there is no forest.

pgsql-general by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues
Next
From: Radosław Smogura
Date:
Subject: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues