Re: COMMENTS are not being copied in CREATE TABLE LIKE

On 13/02/2026 10:19, Jim Jones wrote:
> ...
> Example:
>
> CREATE TABLE t1 (a int);
> COMMENT ON TABLE t1 IS 'comment from table 1';
> CREATE TABLE t2 (b int);
> COMMENT ON TABLE t2 IS 'comment from table 2';
> CREATE TABLE t3 (c int);
> COMMENT ON TABLE t3 IS 'comment from table 3';
>
> CREATE TABLE tm (
> LIKE t1 INCLUDING COMMENTS,
> LIKE t3 INCLUDING COMMENTS,
> LIKE t2 INCLUDING COMMENTS
> );
>
> SELECT obj_description('tm'::regclass, 'pg_class') AS table_comment;
> table_comment
> ----------------------
> comment from table 1+
> comment from table 3+
> comment from table 2
> (1 row)
>
>
> Any thoughts on that?

Rebase

Best, Jim