Request a Demo
Home   >   mailing lists

Re: CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS - Mailing list pgsql-docs

From David G. Johnston
Subject Re: CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS
Date
Msg-id CAKFQuwbzmyEfdJ=LHeBEy0H1A2OYvWu-sOxsG+_qQc+ZZiOJog@mail.gmail.com
Whole thread Raw
In response to CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS  (jian he <jian.universality@gmail.com>)
List pgsql-docs
Tree view
On Saturday, September 6, 2025, jian he <jian.universality@gmail.com> wrote:
hi.

https://www.postgresql.org/docs/devel/sql-createtable.html#SQL-CREATETABLE-PARMS-LIKE-OPT-COMMENTS
"""
INCLUDING COMMENTS
Comments for the copied columns, constraints, and indexes will be copied. The
default behavior is to exclude comments, resulting in the copied columns and
constraints in the new table having no comments.
"""

The above description should mention that comments on extended
statistics will be
copied as well?


How about “If specified, existing comments on any copied elements are copied as well.” ?  Let’s fix this by removing the duplication of the list of things allowed to be copied, not by fixing the oversight the duplication permitted.

David J.

pgsql-docs by date:

Previous
From: jian he
Date:
Subject: CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS
Next
From: Vik Fearing
Date:
Subject: Re: SELECT List with/without parentheses