Re: How PostgreSQL handles Binary Large Objects (LOB/BLOB): types BYTEA, OID/pg_largeobjects and DATALINK

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stefan Keller <sfkeller(at)gmail(dot)com>
Cc: pgsql-general List <pgsql-general(at)postgresql(dot)org>
Subject: Re: How PostgreSQL handles Binary Large Objects (LOB/BLOB): types BYTEA, OID/pg_largeobjects and DATALINK
Date: 2012-01-06 18:41:13
Message-ID: 19558.1325875273@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stefan Keller <sfkeller(at)gmail(dot)com> writes:
> The Wiki page about ORACLE and BLOBs [2] seems to me little bit
> outdated. It says "Binary large object support in Postgres is very
> poor and unsuitable for use in a 24/7 environment, because you can't
> dump them with pg_dump."

That whole page is largely obsolete, I think, but that particular
claim hasn't been true since 8.1 or so.

> There's the new data type DATALINK [5].

AFAICT that page is a wish-list. It certainly doesn't describe any
committed code, and if there's work in progress for that, I don't
know about it.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bulgrien, Kevin 2012-01-06 19:27:58 Re: DROP ROLE prevented by dependency
Previous Message Tom Lane 2012-01-06 18:22:10 Re: DROP ROLE prevented by dependency