{"Entry":{"collection":"catalog","key":"pg_seclabels","name":"pg_seclabels","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","order":false,"removed":[],"status":"added","to":"9.1","types":[]}],"column_count":8,"content_hash":"657b84bc5df56e1728e4e8d4034fb78ab23526f49868168de83b59635a8ba6a1","first_version":"9.1","imported_at":"2026-09-30T00:40:55.791247+08:00","kind":"view","last_version":"20","name":"pg_seclabels","position":71,"present_in":["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":"v","shared":false,"source_rev":"english-manuals:1b94f4dca78b3bd3a87f45312130bea23960c335c69b1e046a49f441b55f5c76","summary":"The view pg_seclabels provides information about security labels.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_seclabels","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_seclabels","SourceRevision":"english-manuals:1b94f4dca78b3bd3a87f45312130bea23960c335c69b1e046a49f441b55f5c76","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"The OID of the object this security label pertains to","description_zh":"","documented":true,"documented_name":"objoid","hidden":false,"name":"objoid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"The OID of the system catalog this object appears in","description_zh":"","documented":true,"documented_name":"classoid","hidden":false,"name":"classoid","not_null":false,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":3,"description":"For a security label on a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is zero.","description_zh":"","documented":true,"documented_name":"objsubid","hidden":false,"name":"objsubid","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":4,"description":"The type of object to which this label applies, as text.","description_zh":"","documented":true,"documented_name":"objtype","hidden":false,"name":"objtype","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":5,"description":"The OID of the namespace for this object, if applicable; otherwise NULL.","description_zh":"","documented":true,"documented_name":"objnamespace","hidden":false,"name":"objnamespace","not_null":false,"references":"pg_namespace.oid","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":6,"description":"The name of the object to which this label applies, as text.","description_zh":"","documented":true,"documented_name":"objname","hidden":false,"name":"objname","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":7,"description":"The label provider associated with this label.","description_zh":"","documented":true,"documented_name":"provider","hidden":false,"name":"provider","not_null":false,"references":"pg_seclabel.provider","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":8,"description":"The security label applied to this object.","description_zh":"","documented":true,"documented_name":"label","hidden":false,"name":"label","not_null":false,"references":"pg_seclabel.label","type":"text","type_modifier":-1,"type_oid":25}],"description":"The view pg_seclabels provides information about security labels. It as an easier-to-query version of the pg_seclabel catalog.","description_zh":"","doc":{"anchor":"id-1.10.5.27.4","file":"view-pg-seclabels.html","lang":"en","sha256":"02bee5976d6625ca7217af72ee519667fbef288076abac6177ae8ebb09aec79f","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","objsubid","objtype","objnamespace","objname","provider","label"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.27.4","file":"view-pg-seclabels.html","lang":"en","sha256":"02bee5976d6625ca7217af72ee519667fbef288076abac6177ae8ebb09aec79f","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["objoid","classoid","objsubid","objtype","objnamespace","objname","provider","label"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_seclabels","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_seclabels","Summary":"视图pg_seclabels提供有关安全标签的信息。它是 pg_seclabel目录的更易查询版本。","BodyHTML":"\u003cp\u003e视图pg_seclabels提供有关安全标签的信息。它是 pg_seclabel目录的更易查询版本。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"ec8c17409b9d32ae4e4ce04dc55b92027e6f5fc67cfd3470135f60296ecb8e78","Payload":{"columns":[{"description_zh":"该安全标签依附的对象的OID","name":"objoid","type":"oid","zh_from":"doc"},{"description_zh":"该对象所在的系统目录的 OID","name":"classoid","type":"oid","zh_from":"doc"},{"description_zh":"对于一个在表列上的安全标签，这将是列号（objoid和classoid指表本身）。对于所有其他对象类型，本列为0。","name":"objsubid","type":"integer","zh_from":"doc"},{"description_zh":"此标签所应用于的对象类型（文本形式）。","name":"objtype","type":"text","zh_from":"doc"},{"description_zh":"如果适用，为此对象的名字空间 OID；否则为 NULL。","name":"objnamespace","type":"oid","zh_from":"doc"},{"description_zh":"此标签所应用于的对象名（文本形式）。","name":"objname","type":"text","zh_from":"doc"},{"description_zh":"与此标签相关的标签提供者。","name":"provider","type":"text","zh_from":"doc"},{"description_zh":"应用于此对象的安全标签。","name":"label","type":"text","zh_from":"doc"}],"description_zh":"视图pg_seclabels提供有关安全标签的信息。它是 pg_seclabel目录的更易查询版本。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}