MIME-Version: 1.0
References: 
 <CANxoLDdJsRJqnjMXV3yjsk07Z5iRWxG-c2hZJC7bAKqf8ZXj_A@mail.gmail.com>
 <202510151529.s3fpwsgben57@alvherre.pgsql>
 <CANxoLDfXKWRQ0KZFtaChr2NX3UWSQq3ji7OJqBp-_-th2Zj6Fg@mail.gmail.com>
 <aP-hllbRdgqbmB8L@ltdrgnflg2>
 <CANxoLDc8UnFuKA2RX6UR_KZWRH6itmrhXK7hoFyF=5kCyfFOGA@mail.gmail.com>
 <CANxoLDfyk_+h91FNq5VNemXTBpES0aLPtLp2myTyWgquUHSQ3A@mail.gmail.com>
 <CANxoLDfw=ERY89RR08s+qXwgUQvLCFF0pVG_e0fDT14rwZsWRg@mail.gmail.com>
 <CAB-JLwYpfK3WCFJ1MT1sAB7Zj9w61wv7fMuCH2vZGW9W4JP15w@mail.gmail.com>
 <CANxoLDdV-ciaYqhWiZCRh3Nv+iW9o1LOGvS83TCZ=5X261OjNA@mail.gmail.com>
In-Reply-To: 
 <CANxoLDdV-ciaYqhWiZCRh3Nv+iW9o1LOGvS83TCZ=5X261OjNA@mail.gmail.com>
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Fri, 7 Nov 2025 11:47:36 -0300
Message-ID: 
 <CAB-JLwaDPJupWecAsvmNc7y7L5cQjV5P9epSFsTed1hEDbqUSA@mail.gmail.com>
Subject: Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE
 POLICY statement
To: Akshay Joshi <akshay.joshi@enterprisedb.com>
Cc: Mark Wong <markwkm@gmail.com>,
 =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>,
	pgsql-hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006403820643024561"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB-JLwaDPJupWecAsvmNc7y7L5cQjV5P9epSFsTed1hEDbqUSA%40mail.gmail.com>
Precedence: bulk

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

Em sex., 7 de nov. de 2025 =C3=A0s 11:27, Akshay Joshi <
akshay.joshi@enterprisedb.com> escreveu:

> I don=E2=80=99t think we need that statement. Could you please elaborate =
on where
> exactly it needs to be added?
>

well, these pg_get_..._ddl() functions will be cool for compare/clone
schemas in a multi tenant world.
Instead of dump/sed/restore a schema to create a new one, I could use
something like
select pg_get_table_ddl(oid) from pg_class where nspname =3D 'customer_050'
and relkind =3D 'r' union all
select pg_get_constraint_ddl(oid) from pg_constraint inner join pg_class on
... where ... union all
select pg_get_trigger_ddl(oid) from pg_trigger inner join pg_class on
... where ... union all
...

And pg_get_policy_ddl() will be part of these union all selects

Because that would be good to worry about create that only if it does not
exists or drop first too.

regards
Marcos

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

<div dir=3D"ltr"><div dir=3D"ltr"><div>Em sex., 7 de nov. de 2025 =C3=A0s 1=
1:27, Akshay Joshi &lt;<a href=3D"mailto:akshay.joshi@enterprisedb.com">aks=
hay.joshi@enterprisedb.com</a>&gt; escreveu:</div></div><div class=3D"gmail=
_quote gmail_quote_container"><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:=
1ex"><div dir=3D"ltr"><div dir=3D"ltr">I don=E2=80=99t think we need that s=
tatement. Could you please elaborate on where exactly it needs to be added?=
</div></div></blockquote><div><br></div><div class=3D"gmail_default" style=
=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">well, these pg_g=
et_..._ddl() functions will be cool for compare/clone schemas in a multi te=
nant world.</div><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif;color:rgb(102,102,102)">Instead of dump/sed/restore a schema to =
create a new one, I could use something like</div><div class=3D"gmail_defau=
lt" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">select =
pg_get_table_ddl(oid) from pg_class where nspname =3D &#39;customer_050&#39=
; and relkind =3D &#39;r&#39; union all</div><div class=3D"gmail_default" s=
tyle=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">select pg_ge=
t_constraint_ddl(oid) from pg_constraint inner join pg_class on ... where .=
.. union all</div><div class=3D"gmail_default" style=3D"font-family:verdana=
,sans-serif;color:rgb(102,102,102)">select pg_get_trigger_ddl(oid) from pg_=
trigger inner join pg_class on ...=C2=A0where ... union all</div><div class=
=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,10=
2,102)">...</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" s=
tyle=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">And pg_get_p=
olicy_ddl() will be part of these union all selects</div><div class=3D"gmai=
l_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-se=
rif;color:rgb(102,102,102)">Because that would be good to worry about creat=
e that only if it does not exists or drop first too.</div><div class=3D"gma=
il_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-s=
erif;color:rgb(102,102,102)">regards</div><div class=3D"gmail_default" styl=
e=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">Marcos</div></d=
iv></div>

--0000000000006403820643024561--