Message-ID: <fda18ba2-e39f-4e48-9b69-496d349de6bc@uni-muenster.de>
Date: Wed, 25 Mar 2026 10:21:56 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: COMMENTS are not being copied in CREATE TABLE LIKE
To: Carlos Alves <carlos@alves.inf.br>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Chao Li <li.evan.chao@gmail.com>,
 Fujii Masao <masao.fujii@gmail.com>,
 Matheus Alcantara <matheusssilv97@gmail.com>,
 "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>,
 "David G. Johnston" <david.g.johnston@gmail.com>
References: <e08cb97f-0364-4002-9cda-3c16b42e4136@uni-muenster.de>
 <DGD24UA7LASG.11H30IV2AFVA2@gmail.com>
 <CAHGQGwF-uuKkon8Ah9dbMiGKoYmFJyHZnDa_HcWWCXKnh7LJ2Q@mail.gmail.com>
 <50f693ad-faec-4b1b-8de5-88dc90b236b4@uni-muenster.de>
 <A5D95968-7484-461B-AA32-273C9161E9B2@gmail.com>
 <421633.1770957043@sss.pgh.pa.us>
 <5888209c-44b5-438a-abd3-7d07990b3a4c@uni-muenster.de>
 <ceccea29-b7a9-4b79-9a06-6e1197d7f290@uni-muenster.de>
 <CAL-Pge4eWCAu7VcjXhXxFKPwT0jYqG2xG7vRAyZJXcr75voJCA@mail.gmail.com>
Content-Language: de-DE, en-GB
From: Jim Jones <jim.jones@uni-muenster.de>
In-Reply-To: 
 <CAL-Pge4eWCAu7VcjXhXxFKPwT0jYqG2xG7vRAyZJXcr75voJCA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/fda18ba2-e39f-4e48-9b69-496d349de6bc%40uni-muenster.de>
Precedence: bulk

Hi Carlos

On 24/03/2026 19:32, Carlos Alves wrote:
> Just one point I'd like to address is the documentation. Following the
> idea of the other "includings" options wouldn't it be interesting to
> present a more concise text? As a suggestion, it could be something like:
> 
> "Comments on columns, not null and check constraints, indexes, extended
> statistics and the table itself from a source table will be copied. If
> the command references multiple source tables with including clauses,
> any existing table-level comments will be merged into a single entry,
> separated by newlines in the order they were specified."

In the second paragraph of the INCLUDING COMMENTS docs I wrote:

<para>
  If multiple <literal>LIKE</literal> clauses specify
  <literal>INCLUDING COMMENTS</literal> and the source tables have
  table-level comments, these comments will be concatenated in the new
  table, separated by newlines, in the order that the
  <literal>LIKE</literal> clauses appear.
</para>

Which pretty much states the same? Please let me know if I am missing
your point here.


> I've attached some preliminary tests I performed.

Thanks for the thorough tests. Much appreciated!

Best, Jim