Thread: Large Object Question

Large Object Question

From
"Chris White"
Date:
Is there any way of finding out the oids of large objects present in the database? The reason I ask, is I want to a database consistency check and one of those checks is to make sure that there aren't any orphaned large objects or tables with references to non-existent large objects.
 
Chris White

Re: Large Object Question

From
marian
Date:
 
select distinct loid from pg_largeobject;
 

Chris White wrote:

 Is there any way of finding out the oids of large objects present in the database? The reason I ask, is I want to a database consistency check and one of those checks is to make sure that there aren't any orphaned large objects or tables with references to non-existent large objects.Chris White
Attachment