MIME-Version: 1.0
References: 
 <CANxoLDfjQnhM=E6JSyYo9s9OdjqoN8s_3wE5yL=kaDu_X8j-dA@mail.gmail.com>
 <CANxoLDcxmXNHNyPt5v+LaBJVJmyt=j95D7TDE9SepoM7y15t-w@mail.gmail.com>
In-Reply-To: 
 <CANxoLDcxmXNHNyPt5v+LaBJVJmyt=j95D7TDE9SepoM7y15t-w@mail.gmail.com>
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Mon, 8 Jun 2026 16:11:05 -0300
Message-ID: 
 <CAB-JLwZXk95KnOs57fe2d7zaOYf5aAAY2kVF5U7cXYXJmZ9jBg@mail.gmail.com>
Subject: Re: [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE
 statements
To: Akshay Joshi <akshay.joshi@enterprisedb.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ddc3810653c2c747"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB-JLwZXk95KnOs57fe2d7zaOYf5aAAY2kVF5U7cXYXJmZ9jBg%40mail.gmail.com>
Precedence: bulk

--000000000000ddc3810653c2c747
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Em seg., 8 de jun. de 2026 =C3=A0s 08:30, Akshay Joshi <
akshay.joshi@enterprisedb.com> escreveu:

> Hi Hackers,
>
> Attached is the v2 patch, which fixes the Meson build failure, and the
> rebased patch.
>

Would be good to have an option "schema-qualified" boolean, because
sometimes I don't want a schema-qualified result.
Suppose you are duplicating a schema, the way your did you cannot do
something like this to have a complete script to generate a new schema

select 'create schema new_schema;' union all
select 'set search_path to new_schema, public;' union all
select string_agg(pg_get_table_ddl(oid),',') from pg_class where
relnamespace::regnamespace::text =3D 'old_schema' and relkind =3D 'r';

regards
Marcos

--000000000000ddc3810653c2c747
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:verdana,sans-serif;color:rgb(102,102,102)"><span style=3D"font-fam=
ily:Arial,Helvetica,sans-serif;color:rgb(34,34,34)">Em seg., 8 de jun. de 2=
026 =C3=A0s 08:30, Akshay Joshi &lt;<a href=3D"mailto:akshay.joshi@enterpri=
sedb.com">akshay.joshi@enterprisedb.com</a>&gt; escreveu:</span></div></div=
><div class=3D"gmail_quote gmail_quote_container"><blockquote class=3D"gmai=
l_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,20=
4,204);padding-left:1ex"><div dir=3D"ltr">Hi Hackers,<br><br>Attached is th=
e v2 patch, which fixes the Meson build failure, and the rebased patch.</di=
v></blockquote><div><br></div><div class=3D"gmail_default" style=3D"font-fa=
mily:verdana,sans-serif;color:rgb(102,102,102)">Would be good to have an op=
tion &quot;schema-qualified&quot; boolean, because sometimes I don&#39;t wa=
nt a schema-qualified result.</div><div class=3D"gmail_default" style=3D"fo=
nt-family:verdana,sans-serif;color:rgb(102,102,102)">Suppose you are duplic=
ating a schema, the way your did you cannot do something like this to have =
a complete script to generate a new schema</div><div class=3D"gmail_default=
" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)"><br></div=
><div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color=
:rgb(102,102,102)">select &#39;create schema new_schema;&#39; union all</di=
v><div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;colo=
r:rgb(102,102,102)">select &#39;set search_path to new_schema, public;&#39;=
 union all</div><div class=3D"gmail_default" style=3D"font-family:verdana,s=
ans-serif;color:rgb(102,102,102)">select string_agg(pg_get_table_ddl(oid),&=
#39;,&#39;) from pg_class where relnamespace::regnamespace::text =3D &#39;o=
ld_schema&#39; and relkind =3D &#39;r&#39;;</div><div class=3D"gmail_defaul=
t" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)"><br></di=
v><div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;colo=
r:rgb(102,102,102)">regards</div><div class=3D"gmail_default" style=3D"font=
-family:verdana,sans-serif;color:rgb(102,102,102)">Marcos</div></div></div>

--000000000000ddc3810653c2c747--