Обсуждение: Large Object Question

Поиск
Список
Период
Сортировка

Large Object Question

От
"Chris White"
Дата:
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

От
marian
Дата:
 
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
Вложения