Re: Lost my blobs and can't restore.

Hmmm, still don't know if pg_restore will add the comments back....

Anyway I was able to recover my comments by sql that looks like

insert into pg_description values(22160 , 16404, 0, 'robasnowman.jpg')

the 22160 is the oid that represented the picture 'robasnowman.jpg'
16404 is the oid that identifies large objects,
0 is a subclass oid currently 0
'robasnowman.jpg' or whatever you want is the 'comment'

You have to be superuser to write the table (I think)

Fortunately I am getting ready to release the next version 1.3.3 of
BiggerSQL , it has the capability to display images stored in oids
and bytea fields so I was able to make a reasonable comment.

Jerry