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 1wPpOI-0013se-0V for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2026 22:27:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wPpOE-008cyp-1r for pgsql-hackers@arkaria.postgresql.org; Wed, 20 May 2026 22:27:47 +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 1wPpOE-008cyh-0i for pgsql-hackers@lists.postgresql.org; Wed, 20 May 2026 22:27:47 +0000 Received: from mail-qk1-x735.google.com ([2607:f8b0:4864:20::735]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wPpOD-000000000WZ-0HLt for pgsql-hackers@lists.postgresql.org; Wed, 20 May 2026 22:27:46 +0000 Received: by mail-qk1-x735.google.com with SMTP id af79cd13be357-9125284a8ecso625251785a.1 for ; Wed, 20 May 2026 15:27:44 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779316064; cv=none; d=google.com; s=arc-20240605; b=ZJ+xfDNoK7m6uEYgP0w5M+IpkLV81hX4EYWZghQBfDBj10ZsD30484OfVmwl6T/5+T 4NMhpcXkrW1FuRwBAXFUg3e8n8Qw4gaYQatd65Or/5fdN5L2gC8wXgeuRlTUmjajNhzq lt+dofK1dE0ZRaaqHU51Pfcudt0GNoqzRjFGwU/ncibKrt+Bl2brKcNlSgMY0oETbnyi 5Kn04j/c9d/EyVgkPSW3a2u4A5ray+hoxE/fTHHmuDxdfzrRIFveYcBYefiXaQHbs/nq 84PWJ6FYFsbGAYhG1xaT/pyrBd6HnhwhJyFXQ1OR+prh6ACJYoP1Fj463QDtRQvDY3i8 /Wvw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=BVgSAHGbmp8Q53F/PSA4CLxyGG3gG0gHZIgSgLmpmNY=; fh=/YpDvpsKzRXAFaF1FdEs/Vh1BM5FXrXkJQJpj2Z4iG4=; b=H2x78Uw0mYHZtUfe47F3gxSDpax2ryoEITVGpTIW588rBZZSvDIj1x0k20oyzXEBkE 511pI46ysp0cq+WuXQUBn/SPed3cbhvlB2ESIQC6pvTEoZaf6y0KewPtyD7rfmI8W6Cd +9WImDgRvnESissjdIOApm4rlfkAHLHUImrCpDtxA7N5ejq7QKz1LGrUywLLFkkrDHw7 EW12gMVIMlQh1PYajSg7MXJBsb3XcaVWeyibS8fzPLCSCjs5ZVzDoYC46wuw/ciNA6oT pLU8aUMlKSFbg2TqQNqtK94YF64BuYe4tfKCGHmDKm35XDLAl/jyCGq3Uk0BCsEdesh/ zAKQ==; 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=20251104; t=1779316064; x=1779920864; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=BVgSAHGbmp8Q53F/PSA4CLxyGG3gG0gHZIgSgLmpmNY=; b=WpkG3a8ZKGBy9PEtt3iuW5WVcwURPYS0wcEr+AlwTh1oy7zNSvFK4BlF2+qV8bmMOH SokZYlLalZd29sI6HaCsZVwGOUsL5Ne9hNk4iKysAG1D5QGEBJzggpcizpRaXC72di/h NiFaIBCRDytTJMdtKhFYG+P3/yuAyvXtt4iMnEO75Y4PzvtJOS61bqCR8FDHI7dur7C1 EoVt7YxJ9sURb9BFOBTnL8koPeBcAz8rc5oRzLR5KnOoQgsjSHyhJFhwNKTtSo3yq59h ERfBgy7S17mYsxvNsrn+dsYiEMYSaMVH//kTFsRejvvYdtATi1mFxb/+4ctaHEfCOos8 QvvA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779316064; x=1779920864; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=BVgSAHGbmp8Q53F/PSA4CLxyGG3gG0gHZIgSgLmpmNY=; b=GQYcdrPUsflhoadQj0p3B89FDC+KBO3RQ2A9Y9gKmj0eHUh/XE9m6vFkcz8CtzGFMp fJVilhoEzUdiBx2xwZs1GtRugk2Qy0VmG7l1nd0dRWCfN/bIV9NezNnpgnOcd7DxSKJT AE95DrZCndTLq/I2ufse42l4+3RIKK6db9I6MzYLnml9OxYlNUpC5c3ADA+K7eI3+8o+ bY4+yMRVqQrmP7KdNJ3kilkbA9jcQZbN4xBqnJGdwkkqqpOdD2S7/1oT0fZEe8Ab1J8G dAjXp+ti46e8q7Dc529dfYxo2p2vuabEgXKywZDvCMSTxrFDOa5N7Pw6T0XynHY6uuYr K7Eg== X-Gm-Message-State: AOJu0YxRMeXnrcDI8LrzpGM4aKGYIPl5HNlep4fbgW0uLK14lz3Jnw4i Rmy4bR/AxLt2UxJOVPKXqkBtLMbQUqx0lGhSdpOBSa9kyRRdnrTDv/RI1LjcFgyPCYFjYn8u9Lc 5rOTr39sqtJyf17GhTI7SKG5Vy+grc0s= X-Gm-Gg: Acq92OH32Hw6fHydClGkKNj4vqnt/2rLKvE/mCXZD/VK5TCTOxqOvNtup78ez+8ZToH V4yiVND4YqHpcWnhscIMK1/qIIJF7dcyxEbq8IroKTlM8Jd8rq1CmEqZjt8QgTdXEmx28YS4oo0 bwiYtVuUEgYZaVng0n61ZW+pQ6gJd3iZYvKIGxhp18KFr2MGxQVUjzB8AVfBWnL76s90R5iasGd +n/racZF2Hifc6ShXGvwsfVlMdlmOKNOC1dernWX3i4UHqs0NmQjirsHMau7843Rp+39ZcO5Qp2 g6LqUK4= X-Received: by 2002:a05:620a:31a9:b0:8d9:e4d:47a8 with SMTP id af79cd13be357-914a2a9789amr27942885a.26.1779316063800; Wed, 20 May 2026 15:27:43 -0700 (PDT) MIME-Version: 1.0 References: <70d20c14d1c14f93e4200c1a9327b97d7c18a782.camel@gmail.com> In-Reply-To: From: Peter Smith Date: Thu, 21 May 2026 08:27:15 +1000 X-Gm-Features: AVHnY4LQOQMxh7r1a3HWd3LGmiXjSh0zj1nXiphZpmwAkB7vlINBYBFCugyy3D8 Message-ID: Subject: Re: Add pg_get_publication_ddl function To: "Jonathan Gonzalez V." Cc: pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, May 20, 2026 at 7:39=E2=80=AFPM Peter Smith = wrote: ... > > 18. > + CREATE PUBLICATION testpub_ddl_1 > + > + WITH (publish=3D'insert, update, delete, truncate', > publish_generated_columns=3D'none', publish_via_partition_root=3D'false')= ; > > ~ > > This "pretty" output appears to have "+" garbage in it. What's that > about -- it looks like some sort of line continuation character? Can > it be removed? > Later, I learned that this is a character added by psql to indicate rows that span multiple lines. So, please ignore this comment. =3D=3D=3D=3D=3D=3D Kind Regards, Peter Smith. Fujitsu Australia