summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2024-07-17 15:17:52 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2024-07-17 15:17:52 -0400
commit4cbd8c60223bd28aacb38f8c8921fc5b8a704fcd (patch)
treee64ae120cb6ba494e8b4ea5de4422a138e458147
parent925479b8d83c2fc819e05bf67335255c13d8e8de (diff)
Doc: fix minor syntax error in example.
The CREATE TABLE option is GENERATED BY DEFAULT *AS* IDENTITY. Per bug #18543 from Ondřej Navrátil. Seems to have crept in in a37bb7c13, so back-patch to v17 where that was added. Discussion: https://postgr.es/m/18543-93c721689f9928e8@postgresql.org
-rw-r--r--doc/src/sgml/ddl.sgml2
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index 9b71c97bdf1..4240c342616 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -257,7 +257,7 @@ CREATE TABLE people (
or alternatively
<programlisting>
CREATE TABLE people (
- id bigint <emphasis>GENERATED BY DEFAULT IDENTITY</emphasis>,
+ id bigint <emphasis>GENERATED BY DEFAULT AS IDENTITY</emphasis>,
...,
);
</programlisting>