Darcy Buskermolen <darcy at wavefire.com> writes:

> For this how does the large object dump/restore facility work in PG now (I 
> think it's a contrib package)

No, it's built into pg_dump/pg_restore.  The restore process fixes up
the LOIDs on the fly, as long as the referencing field is of type
"oid" or a derivative.  If you are referencing the LOID with an int4
field you will end up with a broken database after restore...

-Doug