Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vqkhX-00HDGC-0q for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Feb 2026 04:22:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vqkhU-00CRAG-2k for pgsql-hackers@arkaria.postgresql.org; Fri, 13 Feb 2026 04:22:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vqkhU-00CRA8-1j for pgsql-hackers@lists.postgresql.org; Fri, 13 Feb 2026 04:22:41 +0000 Received: from mail-oa1-x33.google.com ([2001:4860:4864:20::33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vqkhS-00000000OI7-3piP for pgsql-hackers@lists.postgresql.org; Fri, 13 Feb 2026 04:22:40 +0000 Received: by mail-oa1-x33.google.com with SMTP id 586e51a60fabf-40ee8b4f925so381908fac.3 for ; Thu, 12 Feb 2026 20:22:39 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770956559; cv=none; d=google.com; s=arc-20240605; b=THVIeMU+dsQc5Uwcic/phYTHGVVl3ruYGC8EAgSDp0BA3vI7JEC5mrFBAoItKtTO6R /lUVwo3VxspEeGba4KoNk1SK/eNAFhC7F5Y8N3z95i4kvSKz7JeMa035ma4feNScPLrv YyEvo+qM8WTX1tb/WGYOw2XbZUQjHpGBwwT0x+gIrA6yyYPIHHZm74LCvMy4BE7aFU+a ql/bk/qahEBG9T7SqgczvkFi9uAwks803RK22mkYj+kbsBxTsATpzFA/1hDBnOkrnFwI VdDQBiTv1GPvibZCjuZOWiKR2nxJqjU5I9wDYtL+FcMmq02MICub5tO1tByc5ufBfCL7 ppKQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=nwoayUv6WCi61quBWJ0JQWQ9RX3Q0MZ9QmS3qQijkWE=; fh=ozdZrNUI3wVEYoINSceYOL/qLGZMeeQL+tPMt9FIyd0=; b=kiPXyZsY1gPA1oF7qR+Ldx1OmUOUrNfq/v4ArrFcuHQlZJK+O+D03yGU6316WwbZk1 y1ceHKKvGRwLQNKfDy6Srn3iiIqAopWlkf/PDhTxE/Yuoq06dKlYUz8Mb3hPNY+2WyQo QdCa5xCiwm3gOvycAnG51LKVne4iKLwu+Bj39ITzBqUhzMDCgY27QgwWuZeE7JoIK2Cy M0Y4gedRExg3aFHTJrdLkas75q5JAo9m3qC4TuHKqvziFUp2r3x0SidC5peRpfnOLXeG bu43nOveHoD8WSzg1OhrMWBebX9hCDKwk4sByxzolZa0o/1C/GBSbISR2YPW05Z5eRjC j1MQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1770956559; x=1771561359; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=nwoayUv6WCi61quBWJ0JQWQ9RX3Q0MZ9QmS3qQijkWE=; b=nIeRO4Jw6gAXXomkTIMRIu64Ow6lZyoIxl3GrahetNKSLBGQ7PZfVs2i3o2WMrRCzS mbpmzWGOKvYbyAApEG+jGYNNaQHpfj3KBT5pepnH/0ROldIrqQ1ssoJF5BUFlBaTYAgZ R5v8S2G0/9In5xa9M7QyHcKLVNzM97iHD2KmCNnPGwA40Q2f6zTBjRShfSNr2tfDAL5R /eQnpu6rgND/SCkKRoUAZKrKgpumeS9sTfVHN897jrIPbJhcNlK+AnIlIwC4bMNQr727 yHL+ApuzKDKSJhIP0qmnvbkfqueexar2NRudvPUAoDFI/juSR+8KIm82K+8Ubd2AdVF3 HzuA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770956559; x=1771561359; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=nwoayUv6WCi61quBWJ0JQWQ9RX3Q0MZ9QmS3qQijkWE=; b=fYV7IZBboScLxPV4MQ6ePvaydTK1T54dmc9l+oz4xeXUq0O4DgSAWn4/B89nyDawb4 hEICHOMfNaee/1/GhnLvm0kLp0rE7wJtJiXFDXvmMO9W5YnTboVyCU9e0dUy+xJKz/j0 A0ekA5Ps5AnwuvxOoFk2XFrThxE0UV6WQvK/xHQm8fv7arEsAbztyuPsJEJbzDu//GT9 NKBIilVqGYGZx1TCi0IGGqf6kpdX/4YYiXsMM9DCKEkoP5tcVtB1I3GeG9Ep7NzzJ4ZG iSSfaBTynRR0OhKYPzXmT3XDanNRGcsXKmeSM1ICh2UVoNiObGtt66Ni8AcFMW1Ep+jO F3TQ== X-Forwarded-Encrypted: i=1; AJvYcCXe72+X9NJi6vNlElqsZAzvoNTEV5MUPKiY9+1yoqf63trSd6q4CPtRuKP3Uwpe+fbEma0EnEn1Gq9vAjbj@lists.postgresql.org X-Gm-Message-State: AOJu0Yy7mbVe9bgieVVg+/OVWEN062otSesZ0GU0pEokbOJvp/pZwOKd cbVZUYtVndkp5pHDuQGlwaKGt9G3jiImjx3LIEyexkSU06VDb2e9atvedpZ/GlaJEgeZHxVY08S ShJIiuY0+ccfdAsyGQntQh1Nzd48f+XI= X-Gm-Gg: AZuq6aLc9ItE29RnAomt1Fpk1P2bnO/kys2huxK63gdlLXZsLLW6U/BqS+J7WHTLBys kQlhNBmVdgirlNQqkZblxctruXu10D5N/YUTxJNmGGzdwUNzTUCTb1P2rgFCObzlGCr5zZ0KNew 6bWdBBexP8hgFmmEi9BieXfnNteQHX48OWDkBC33Ep9yKA8jCbzPkmATeqZGzoqN/BzT4l3rfQu TQHU1mw4YRITlnXlYBvCt+0FGPIXBWfZkC5S+fmHn8/CXXyvzFIiJPd3y9jS6cOon3pWbKqR7af SbVH7uKx X-Received: by 2002:a05:6871:d608:b0:3f4:fed5:d88b with SMTP id 586e51a60fabf-40ef3e2bf0dmr338418fac.35.1770956559014; Thu, 12 Feb 2026 20:22:39 -0800 (PST) MIME-Version: 1.0 Received: by 2002:ac9:67ce:0:b0:61e:e94d:df0d with HTTP; Thu, 12 Feb 2026 20:22:38 -0800 (PST) In-Reply-To: References: <50f693ad-faec-4b1b-8de5-88dc90b236b4@uni-muenster.de> From: "David G. Johnston" Date: Thu, 12 Feb 2026 21:22:38 -0700 X-Gm-Features: AZwV_Qi-oCmcIo8Wry28HRYvUCyORBcjjRyDSMxbUirh3ce5_DyY2AVtxd_FdV0 Message-ID: Subject: Re: COMMENTS are not being copied in CREATE TABLE LIKE To: Fujii Masao Cc: Jim Jones , Matheus Alcantara , "pgsql-hackers@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000009ce0c3064aacf405" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009ce0c3064aacf405 Content-Type: text/plain; charset="UTF-8" On Thursday, February 12, 2026, Fujii Masao wrote: > > > For example, if two source tables each have a table comment and both are > specified in LIKE, which comment should be applied to the new table? > Both, with a new line between them. David J. --0000000000009ce0c3064aacf405 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thursday, February 12, 2026, Fujii Masao <masao.fujii@gmail.com> wrote:

For example, if two source tables each have a table comment and both are specified in LIKE, which comment should be applied to the new table?

Both, with a new line between them.
<= div>
David J.
=C2=A0
--0000000000009ce0c3064aacf405--