{"Entry":{"collection":"catalog","key":"pg_attrdef","name":"pg_attrdef","aliases":[],"metadata":{"changed_in":["9.1","12"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.0","listing":[],"order":false,"removed":[],"status":"changed","to":"9.1","types":[{"from":"text","name":"adbin","to":"pg_node_tree"}],"unlisted":[]},{"added":[],"attributes":[{"attribute":"not_null","from":false,"name":"adbin","to":true},{"attribute":"hidden","from":true,"name":"oid","to":false}],"description_changed":true,"descriptions":[{"from":"The internal representation of the column default value","name":"adbin","to":"The column default value, in nodeToString() representation. Use pg_get_expr(adbin, adrelid) to convert it to an SQL expression."}],"from":"11","listing":[],"order":false,"removed":["adsrc"],"status":"changed","to":"12","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[{"from":"The column default value, in nodeToString() representation. Use pg_get_expr(adbin, adrelid) to convert it to an SQL expression.","name":"adbin","to":"The column default or generation expression, in nodeToString() representation. Use pg_get_expr(adbin, adrelid) to convert it to an SQL expression."}],"from":"17","listing":[],"order":false,"removed":[],"status":"reworded","to":"18","types":[],"unlisted":[]}],"column_count":4,"content_hash":"9f7ff408d32293f03d01ef11426f7cac439fd91921d616e9fdc3c199557ea740","derived_content_hash":"9770e91c57ceb73fd5eb9241bccec81cf0da18fec093b77500c52399ac84006a","first_version":"7.4","imported_at":"2026-09-30T00:40:55.329228+08:00","kind":"catalog","last_version":"20","name":"pg_attrdef","position":5,"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:471cb6997385d2e4964536271ab22e293b13f4be1afd7383c52bb1bef7568590","summary":"The catalog pg_attrdef stores column default expressions and generation expressions.","summary_zh":"目录 pg_attrdef 存储列默认表达式和生成表达式。列的主要信息存储在 pg_attribute 中。只有显式设置了默认表达式或生成表达式的列，才会在此目录中有条目。"}},"Definition":{"Collection":"catalog","Key":"pg_attrdef","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_attrdef","SourceRevision":"catalog-bilingual-repair:471cb6997385d2e4964536271ab22e293b13f4be1afd7383c52bb1bef7568590","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The table this column belongs to","description_zh":"该列所属的表","documented":true,"documented_name":"adrelid","hidden":false,"name":"adrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The number of the column","description_zh":"列的编号","documented":true,"documented_name":"adnum","hidden":false,"name":"adnum","not_null":true,"references":"pg_attribute.attnum","type":"int2","type_modifier":-1,"type_oid":21,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"The column default or generation expression, in nodeToString() representation. Use pg_get_expr(adbin, adrelid) to convert it to an SQL expression.","description_zh":"列默认表达式或生成表达式的内部表示，采用 nodeToString() 的输出格式。可使用 pg_get_expr(adbin, adrelid) 将其转换为 SQL 表达式。","documented":true,"documented_name":"adbin","hidden":false,"name":"adbin","not_null":true,"references":"","type":"pg_node_tree","type_modifier":-1,"type_oid":194,"zh_from":"same-version-manual"}],"description":"The catalog pg_attrdef stores column default expressions and generation expressions. The main information about columns is stored in pg_attribute. Only columns for which a default expression or generation expression has been explicitly set will have an entry here.","description_zh":"目录 pg_attrdef 存储列默认表达式和生成表达式。列的主要信息存储在 pg_attribute 中。只有显式设置了默认表达式或生成表达式的列，才会在此目录中有条目。","description_zh_html":"\u003cp\u003e目录 pg_attrdef 存储列默认表达式和生成表达式。列的主要信息存储在 pg_attribute 中。只有显式设置了默认表达式或生成表达式的列，才会在此目录中有条目。\u003c/p\u003e","doc":{"anchor":"id-1.10.4.8.4","file":"catalog-pg-attrdef.html","lang":"en","sha256":"8cf6afeedabd33b9758a0abd99923e7fdf1ffadc0c6c484d5ac9d7e090f08e83","slug":"18"},"kind":"catalog","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","adrelid","adnum","adbin"],"runtime_verified":false,"source":"english-manual","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-attrdef.html","sha256":"380970b495d9e55306a15b591f6701bc37f6186178915602c5a69f03872718c2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:b81a408327b8188f5fa59856a8b1162a81d235da44b714639308998c4d16df3c","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.4.8.4","file":"catalog-pg-attrdef.html","lang":"en","sha256":"8cf6afeedabd33b9758a0abd99923e7fdf1ffadc0c6c484d5ac9d7e090f08e83","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"catalog-pg-attrdef.html","sha256":"380970b495d9e55306a15b591f6701bc37f6186178915602c5a69f03872718c2","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:b81a408327b8188f5fa59856a8b1162a81d235da44b714639308998c4d16df3c","version":"18"}]},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["oid","adrelid","adnum","adbin"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_attrdef","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_attrdef","Summary":"The catalog pg_attrdef stores column default expressions and generation expressions. The main information about columns is stored in pg_attribute. Only columns for which a default expression or generation expression has been explicitly set will have an entry here.","BodyHTML":"\u003cp\u003eThe catalog pg_attrdef stores column default expressions and generation expressions. The main information about columns is stored in pg_attribute. Only columns for which a default expression or generation expression has been explicitly set will have an entry here.\u003c/p\u003e","SourceRevision":"catalog-bilingual-repair:471cb6997385d2e4964536271ab22e293b13f4be1afd7383c52bb1bef7568590","ContentHash":"5daded4a0da41dc1def364dc2ffebd1273d9abedaca1581ff45a7767af84cc0d","Payload":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Row identifier","description_zh":"行标识符","documented":true,"documented_name":"oid","hidden":false,"name":"oid","not_null":true,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":2,"description":"The table this column belongs to","description_zh":"该列所属的表","documented":true,"documented_name":"adrelid","hidden":false,"name":"adrelid","not_null":true,"references":"pg_class.oid","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"The number of the column","description_zh":"列的编号","documented":true,"documented_name":"adnum","hidden":false,"name":"adnum","not_null":true,"references":"pg_attribute.attnum","type":"int2","type_modifier":-1,"type_oid":21,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"The column default or generation expression, in nodeToString() representation. Use pg_get_expr(adbin, adrelid) to convert it to an SQL expression.","description_zh":"列默认表达式或生成表达式的内部表示，采用 nodeToString() 的输出格式。可使用 pg_get_expr(adbin, adrelid) 将其转换为 SQL 表达式。","documented":true,"documented_name":"adbin","hidden":false,"name":"adbin","not_null":true,"references":"","type":"pg_node_tree","type_modifier":-1,"type_oid":194,"zh_from":"same-version-manual"}],"description":"The catalog pg_attrdef stores column default expressions and generation expressions. The main information about columns is stored in pg_attribute. Only columns for which a default expression or generation expression has been explicitly set will have an entry here."}},"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}