Re: Introduction of a new field in pg_class indicating presence of a large object in a table

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Introduction of a new field in pg_class indicating presence of a large object in a table
Дата
Msg-id CAKFQuwY4xifDbf8EZKwYtrECQiCbYsK_RLo+vnnWN-MuSSaqLQ@mail.gmail.com
обсуждение исходный текст
Ответ на Introduction of a new field in pg_class indicating presence of a large object in a table  (Gaurav Pant <gauravpant145@gmail.com>)
Ответы Re: Introduction of a new field in pg_class indicating presence of a large object in a table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Tue, Apr 30, 2024 at 11:57 AM Gaurav Pant <gauravpant145@gmail.com> wrote:
I wanted to know if there is any such system table that we can use to identify and map the fields containing large objects and the respective tables and if it is not already there, do we have any plans to incorporate the same in pg_class like we have for pg_toast?



Large Objects are nothing like TOAST.  There is no system level association between large objects and tables.  Sure, the DBA can choose to store a large object OID in a table, but how you'd go about figuring out which columns contain those is going to be installation specific.  Though hopefully they used a bigint data type and maybe added "oid" to the column name...I suppose it would be interesting if one could define a FK on a table and point it at pg_largeobject_metadata but that I suspect would be the extent to which we'd do something along the lines of your request.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Gaurav Pant
Дата:
Сообщение: Introduction of a new field in pg_class indicating presence of a large object in a table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Introduction of a new field in pg_class indicating presence of a large object in a table