Size: a a a
MV
MV
SELECT
w.name as workbook_name,
w.luid,
w.content_version as content_version,
w.id as workbook_id,
w.last_published_at as updated_at,
rd.content as content_id
FROM workbooks w
LEFT JOIN repository_data rd on coalesce(w.data_id, w.reduced_data_id) = rd.tracking_idMV
А
SELECT
w.name as workbook_name,
w.luid,
w.content_version as content_version,
w.id as workbook_id,
w.last_published_at as updated_at,
rd.content as content_id
FROM workbooks w
LEFT JOIN repository_data rd on coalesce(w.data_id, w.reduced_data_id) = rd.tracking_idEL
SELECT
w.name as workbook_name,
w.luid,
w.content_version as content_version,
w.id as workbook_id,
w.last_published_at as updated_at,
rd.content as content_id
FROM workbooks w
LEFT JOIN repository_data rd on coalesce(w.data_id, w.reduced_data_id) = rd.tracking_idEL
SELECT
w.name as workbook_name,
w.luid,
w.content_version as content_version,
w.id as workbook_id,
w.last_published_at as updated_at,
rd.content as content_id
FROM workbooks w
LEFT JOIN repository_data rd on coalesce(w.data_id, w.reduced_data_id) = rd.tracking_idEL
pg_largeobject, но там объекты разибиты и хранятся по байтам. С самой таблицей надо через export/import работать.EL
EL
EL
ИА
LS
ВБ
АП
MC
ИА
АП
MC
АП
MC
