diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2024-07-01 08:39:07 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2024-07-01 08:39:07 +0200 |
| commit | da486d360103fbb3cd0d3f3b70134d47e9bb652a (patch) | |
| tree | 69eeb1462bbb95365ef55b301b120b03ca23b43f /doc/src | |
| parent | 2357c9223b710c91b0f05cbc56bd435baeac961f (diff) | |
| download | postgresql-da486d360103fbb3cd0d3f3b70134d47e9bb652a.tar.gz postgresql-da486d360103fbb3cd0d3f3b70134d47e9bb652a.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index dd61e057b21..b654fae1b2f 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -1032,10 +1032,11 @@ <para> The catalog <structname>pg_attrdef</structname> stores column default - values. The main information about columns is stored in - <link linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link>. - Only columns for which a default value has been explicitly set will have - an entry here. + expressions and generation expressions. The main information about columns + is stored in <link + linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link>. + Only columns for which a default expression or generation expression has + been explicitly set will have an entry here. </para> <table> @@ -1087,7 +1088,7 @@ <structfield>adbin</structfield> <type>pg_node_tree</type> </para> <para> - The column default value, in <function>nodeToString()</function> + The column default or generation expression, in <function>nodeToString()</function> representation. Use <literal>pg_get_expr(adbin, adrelid)</literal> to convert it to an SQL expression. </para></entry> |