{"Entry":{"collection":"catalog","key":"pg_tables","name":"pg_tables","aliases":[],"metadata":{"changed_in":["8.0","9.5"],"changes":[{"added":["tablespace"],"attributes":[],"description_changed":false,"descriptions":[],"from":"7.4","listing":[],"order":false,"removed":[],"status":"changed","to":"8.0","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"name of schema containing table","name":"schemaname","to":"Name of schema containing table"},{"from":"name of table","name":"tablename","to":"Name of table"},{"from":"name of table's owner","name":"tableowner","to":"Name of table's owner"},{"from":"name of tablespace containing table (NULL if default for database)","name":"tablespace","to":"Name of tablespace containing table (NULL if default for database)"}],"from":"8.1","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.2","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"true if table has rules","name":"hasrules","to":"true if table has (or once had) rules"},{"from":"true if table has triggers","name":"hastriggers","to":"true if table has (or once had) triggers"}],"from":"8.3","listing":[],"order":false,"removed":[],"status":"reworded","to":"8.4","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"true if table has (or recently had) any indexes","name":"hasindexes","to":"True if table has (or recently had) any indexes"},{"from":"true if table has (or once had) rules","name":"hasrules","to":"True if table has (or once had) rules"},{"from":"true if table has (or once had) triggers","name":"hastriggers","to":"True if table has (or once had) triggers"},{"from":"Name of tablespace containing table (NULL if default for database)","name":"tablespace","to":"Name of tablespace containing table (null if default for database)"}],"from":"8.4","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.0","types":[],"unlisted":[]},{"added":["rowsecurity"],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.4","listing":[],"order":false,"removed":[],"status":"changed","to":"9.5","types":[],"unlisted":[]}],"column_count":8,"content_hash":"f6f482d635a7f5422a012bf72c490352c6bf98966b08c7a686baf5142ea91723","first_version":"7.4","imported_at":"2026-09-30T00:40:56.256702+08:00","kind":"view","last_version":"20","name":"pg_tables","position":138,"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":"v","shared":false,"source_rev":"english-manuals:d3b90a4fcb70a6992ea31eb4d6ad74a5771b8bda7ec779fa5fbe62223efb2541","summary":"The view pg_tables provides access to useful information about each table in the database.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_tables","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_tables","SourceRevision":"english-manuals:d3b90a4fcb70a6992ea31eb4d6ad74a5771b8bda7ec779fa5fbe62223efb2541","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Name of schema containing table","description_zh":"","documented":true,"documented_name":"schemaname","hidden":false,"name":"schemaname","not_null":false,"references":"pg_namespace.nspname","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":2,"description":"Name of table","description_zh":"","documented":true,"documented_name":"tablename","hidden":false,"name":"tablename","not_null":false,"references":"pg_class.relname","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":3,"description":"Name of table's owner","description_zh":"","documented":true,"documented_name":"tableowner","hidden":false,"name":"tableowner","not_null":false,"references":"pg_authid.rolname","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":4,"description":"Name of tablespace containing table (null if default for database)","description_zh":"","documented":true,"documented_name":"tablespace","hidden":false,"name":"tablespace","not_null":false,"references":"pg_tablespace.spcname","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":5,"description":"True if table has (or recently had) any indexes","description_zh":"","documented":true,"documented_name":"hasindexes","hidden":false,"name":"hasindexes","not_null":false,"references":"pg_class.relhasindex","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":6,"description":"True if table has (or once had) rules","description_zh":"","documented":true,"documented_name":"hasrules","hidden":false,"name":"hasrules","not_null":false,"references":"pg_class.relhasrules","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":7,"description":"True if table has (or once had) triggers","description_zh":"","documented":true,"documented_name":"hastriggers","hidden":false,"name":"hastriggers","not_null":false,"references":"pg_class.relhastriggers","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":8,"description":"True if row security is enabled on the table","description_zh":"","documented":true,"documented_name":"rowsecurity","hidden":false,"name":"rowsecurity","not_null":false,"references":"pg_class.relrowsecurity","type":"bool","type_modifier":-1,"type_oid":16}],"description":"The view pg_tables provides access to useful information about each table in the database.","description_zh":"","doc":{"anchor":"id-1.10.5.36.4","file":"view-pg-tables.html","lang":"en","sha256":"0646481d4e5a12f4f98e453a330f1c8c0a676507cf023a11e087f2a774075a21","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","tablename","tableowner","tablespace","hasindexes","hasrules","hastriggers","rowsecurity"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.36.4","file":"view-pg-tables.html","lang":"en","sha256":"0646481d4e5a12f4f98e453a330f1c8c0a676507cf023a11e087f2a774075a21","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["schemaname","tablename","tableowner","tablespace","hasindexes","hasrules","hastriggers","rowsecurity"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_tables","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_tables","Summary":"视图pg_tables提供了对数据库中每个表的有用信息的访问。","BodyHTML":"\u003cp\u003e视图pg_tables提供了对数据库中每个表的有用信息的访问。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"41cd9ef0f679572b7bc9558434d9855422a12165a88922ad974a265839573c65","Payload":{"columns":[{"description_zh":"包含表的模式名称","name":"schemaname","type":"name","zh_from":"doc"},{"description_zh":"表的名称","name":"tablename","type":"name","zh_from":"doc"},{"description_zh":"表拥有者名称","name":"tableowner","type":"name","zh_from":"doc"},{"description_zh":"包含该表的表空间名称（如果使用数据库的默认表空间，此列为 NULL）","name":"tablespace","type":"name","zh_from":"doc"},{"description_zh":"如果表有（或最近有过）任何索引，此列为真","name":"hasindexes","type":"boolean","zh_from":"doc"},{"description_zh":"如果表有（或曾经有过）规则，此列为真","name":"hasrules","type":"boolean","zh_from":"doc"},{"description_zh":"如果表有（或者曾经有过）触发器，此列为真","name":"hastriggers","type":"boolean","zh_from":"doc"},{"description_zh":"如果表上启用了行级安全则为真","name":"rowsecurity","type":"boolean","zh_from":"doc"}],"description_zh":"视图pg_tables提供了对数据库中每个表的有用信息的访问。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","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}