{"Entry":{"collection":"catalog","key":"pg_largeobject","name":"pg_largeobject","aliases":[],"metadata":{"changed_in":["9.5"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Actual data stored in the large object. This will never be more than LOBLKSIZE bytes and may be less.","name":"data","to":"Actual data stored in the large object. This will never be more than LOBLKSIZE bytes and may be less"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Actual data stored in the large object. This will never be more than LOBLKSIZE bytes and may be less","name":"data","to":"Actual data stored in the large object. This will never be more than LOBLKSIZE bytes and might be less"}],"from":"8.2","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.3","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"Actual data stored in the large object. This will never be more than LOBLKSIZE bytes and might be less","name":"data","to":"Actual data stored in the large object. This will never be more than LOBLKSIZE bytes and might be less."}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":[],"attributes":[{"attribute":"not_null","from":false,"name":"data","to":true}],"description_changed":false,"descriptions":[],"from":"9.4","listing":[],"order":false,"removed":[],"status":"changed","to":"9.5","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]}],"column_count":3,"content_hash":"a92daf66fc8faad1954713e45a9fac1f9a6ba325b4796f01c8147d413b57cbed","derived_content_hash":"a6384f2a0e123a96f82581006b10ee14432b40a5920172d820ed9051675d5a9e","first_version":"7.4","imported_at":"2026-09-30T00:40:55.599943+08:00","kind":"catalog","last_version":"20","name":"pg_largeobject","position":41,"present_in":["7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"r","shared":false,"source_rev":"catalog-bilingual-repair:17127ab7a17096839aba6e9b151671c978a7fdbebe580fdb2a26074eaf09b129","summary":"The catalog pg_largeobject holds the data making up “large objects”.","summary_zh":"目录 pg_largeobject 保存构成“大对象”的数据。一个大对象在被创建时会被分配一个 OID。每个大对象被分解成足够小的段或“页”，以便方便地作为行存储在 pg_largeobject 中。每页中的数据量被定义为 LOBLKSIZE（目前是 BLCKSZ/4，通常为 2 kB）。"}},"Definition":{"Collection":"catalog","Key":"pg_largeobject","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_largeobject","SourceRevision":"catalog-bilingual-repair:17127ab7a17096839aba6e9b151671c978a7fdbebe580fdb2a26074eaf09b129","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Identifier of the large object that includes this page","description_zh":"包含此页的大对象的标识符","documented":true,"documented_name":"loid","hidden":false,"name":"loid","not_null":true,"references":"pg_largeobject_metadata.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Page number of this page within its large object (counting from zero)","description_zh":"此页在它所属大对象中的页号（从 0 开始计）","documented":true,"documented_name":"pageno","hidden":false,"name":"pageno","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Actual data stored in the large object. This will never be more than LOBLKSIZE bytes and might be less.","description_zh":"实际存储在大对象中的数据。它从不会超过 LOBLKSIZE 字节，也可能更少。","documented":true,"documented_name":"data","hidden":false,"name":"data","not_null":true,"references":"","type":"bytea","type_modifier":-1,"type_oid":17,"zh_from":"same-version-manual"}],"description":"The catalog pg_largeobject holds the data making up “large objects”. A large object is identified by an OID assigned when it is created. Each large object is broken into segments or “pages” small enough to be conveniently stored as rows in pg_largeobject. The amount of data per page is defined to be LOBLKSIZE (which is currently BLCKSZ/4, or typically 2 kB).\n\nPrior to PostgreSQL 9.0, there was no permission structure associated with large objects. As a result, pg_largeobject was publicly readable and could be used to obtain the OIDs (and contents) of all large objects in the system. This is no longer the case; use pg_largeobject_metadata to obtain a list of large object OIDs.","description_zh":"目录 pg_largeobject 保存构成“大对象”的数据。一个大对象在被创建时会被分配一个 OID。每个大对象被分解成足够小的段或“页”，以便方便地作为行存储在 pg_largeobject 中。每页中的数据量被定义为 LOBLKSIZE（目前是 BLCKSZ/4，通常为 2 kB）。\n\n在 PostgreSQL 9.0 之前，大对象没有相关的权限结构。因此，pg_largeobject 曾是公开可读的，并且可以用来获得系统中所有大对象的 OID（和内容）。但现在已经不是这样了；可使用 pg_largeobject_metadata 来获得大对象 OID 的列表。","description_zh_html":"\u003cp\u003e目录 pg_largeobject 保存构成“大对象”的数据。一个大对象在被创建时会被分配一个 OID。每个大对象被分解成足够小的段或“页”，以便方便地作为行存储在 pg_largeobject 中。每页中的数据量被定义为 LOBLKSIZE（目前是 BLCKSZ/4，通常为 2 kB）。\u003c/p\u003e\n\u003cp\u003e在 PostgreSQL 9.0 之前，大对象没有相关的权限结构。因此，pg_largeobject 曾是公开可读的，并且可以用来获得系统中所有大对象的 OID（和内容）。但现在已经不是这样了；可使用 pg_largeobject_metadata 来获得大对象 OID 的列表。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.32.5","file":"catalog-pg-largeobject.html","lang":"en","sha256":"7b29ed63986db78a9b64073e377d4b4bbc24fbaf12221c1807ae6f1f5ca25fa9","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["loid","pageno","data"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-largeobject.html","sha256":"47568cab9c1755213847a8f86aace9cbc5a64cfdd03f9367100d874fc56a7ebc","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:2c8463cb1ca57a759880ca1a760e8ac061619a944bf31d328b2480d3b9e565ca","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.32.5","file":"catalog-pg-largeobject.html","lang":"en","sha256":"7b29ed63986db78a9b64073e377d4b4bbc24fbaf12221c1807ae6f1f5ca25fa9","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-largeobject.html","sha256":"47568cab9c1755213847a8f86aace9cbc5a64cfdd03f9367100d874fc56a7ebc","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:2c8463cb1ca57a759880ca1a760e8ac061619a944bf31d328b2480d3b9e565ca","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["loid","pageno","data"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_largeobject","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_largeobject","Summary":"The catalog pg_largeobject holds the data making up “large objects”. A large object is identified by an OID assigned when it is created. Each large object is broken into segments or “pages” small enough to be conveniently stored as rows in pg_largeobject. The amount of data per page is defined to be LOBLKSIZE (which is currently BLCKSZ/4, or typically 2 kB).\n\nPrior to PostgreSQL 9.0, there was no permission structure associated with large objects. As a result, pg_largeobject was publicly readable and could be used to obtain the OIDs (and contents) of all large objects in the system. This is no longer the case; use pg_largeobject_metadata to obtain a list of large object OIDs.","BodyHTML":"\u003cp\u003eThe catalog pg_largeobject holds the data making up “large objects”. A large object is identified by an OID assigned when it is created. Each large object is broken into segments or “pages” small enough to be conveniently stored as rows in pg_largeobject. The amount of data per page is defined to be LOBLKSIZE (which is currently BLCKSZ/4, or typically 2 kB).\n\nPrior to PostgreSQL 9.0, there was no permission structure associated with large objects. As a result, pg_largeobject was publicly readable and could be used to obtain the OIDs (and contents) of all large objects in the system. This is no longer the case; use pg_largeobject_metadata to obtain a list of large object OIDs.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:17127ab7a17096839aba6e9b151671c978a7fdbebe580fdb2a26074eaf09b129","ContentHash":"663bf878536d54e11bd70eaa5c7f598e2a3b8663b1fa257573f1ed92ac3f1cef","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Identifier of the large object that includes this page","description_zh":"包含此页的大对象的标识符","documented":true,"documented_name":"loid","hidden":false,"name":"loid","not_null":true,"references":"pg_largeobject_metadata.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"Page number of this page within its large object (counting from zero)","description_zh":"此页在它所属大对象中的页号（从 0 开始计）","documented":true,"documented_name":"pageno","hidden":false,"name":"pageno","not_null":true,"references":"","type":"int4","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Actual data stored in the large object. This will never be more than LOBLKSIZE bytes and might be less.","description_zh":"实际存储在大对象中的数据。它从不会超过 LOBLKSIZE 字节，也可能更少。","documented":true,"documented_name":"data","hidden":false,"name":"data","not_null":true,"references":"","type":"bytea","type_modifier":-1,"type_oid":17,"zh_from":"same-version-manual"}],"description":"The catalog pg_largeobject holds the data making up “large objects”. A large object is identified by an OID assigned when it is created. Each large object is broken into segments or “pages” small enough to be conveniently stored as rows in pg_largeobject. The amount of data per page is defined to be LOBLKSIZE (which is currently BLCKSZ/4, or typically 2 kB).\n\nPrior to PostgreSQL 9.0, there was no permission structure associated with large objects. As a result, pg_largeobject was publicly readable and could be used to obtain the OIDs (and contents) of all large objects in the system. This is no longer the case; use pg_largeobject_metadata to obtain a list of large object OIDs."}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}