Re: CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS

2025-09-06 Thread David G. Johnston
On Saturday, September 6, 2025, jian he  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.


CREATE TABLE LIKE(INCLUDING COMMENTS) description ignored STATISTICS

2025-09-06 Thread jian he
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?