Commitda486d3

committed

doc: Clarify that pg_attrdef also stores generation expressions

This was documented with pg_attribute but not with pg_attrdef.Reported-by: jian he <jian.universality@gmail.com>Discussion:https://www.postgresql.org/message-id/CACJufxE+E-iYmBnZVZHiYA+WpyZZVv7BfiBLpo=T70EZHDU9rw@mail.gmail.com

1 parent2357c92 commitda486d3Copy full SHA for da486d3

File tree

-5

lines changed

-5

lines changed

Lines changed: 6 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -1032,10 +1032,11 @@`
`1032`	`1032`
`1033`	`1033`	`<para>`
`1034`	`1034`	`The catalog <structname>pg_attrdef</structname> stores column default`
`1035`		`- values. The main information about columns is stored in`
`1036`		`- <link linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link>.`
`1037`		`- Only columns for which a default value has been explicitly set will have`
`1038`		`- an entry here.`
	`1035`	`+ expressions and generation expressions. The main information about columns`
	`1036`	`+ is stored in <link`
	`1037`	`+ linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link>.`
	`1038`	`+ Only columns for which a default expression or generation expression has`
	`1039`	`+ been explicitly set will have an entry here.`
`1039`	`1040`	`</para>`
`1040`	`1041`
`1041`	`1042`	`<table>`
`@@ -1087,7 +1088,7 @@`
`1087`	`1088`	`<structfield>adbin</structfield> <type>pg_node_tree</type>`
`1088`	`1089`	`</para>`
`1089`	`1090`	`<para>`
`1090`		`- The column defaultvalue, in <function>nodeToString()</function>`
	`1091`	`+ The column defaultor generation expression, in <function>nodeToString()</function>`
`1091`	`1092`	`representation. Use <literal>pg_get_expr(adbin, adrelid)</literal> to`
`1092`	`1093`	`convert it to an SQL expression.`
`1093`	`1094`	`</para></entry>`

Comments

(0)