Thread

Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement

Akshay Joshi <akshay.joshi@enterprisedb.com> — 2025-11-07T14:27:06Z

On Fri, Nov 7, 2025 at 6:45 PM Marcos Pegoraro <marcos@f10.com.br> wrote:

> Em sex., 7 de nov. de 2025 às 09:21, Akshay Joshi <
> akshay.joshi@enterprisedb.com> escreveu:
>
>> Attached is the v7 patch, which is ready for review.
>>
>>> <https://enterprisedb.com>
>>>>
>>>> For this functionality to be complete, the
> ALTER TABLE ... ENABLE ROW LEVEL SECURITY
> statement needs to be added to the command.
>
> Did you think about that ?
> Maybe one more parameter ?
>

I don’t think we need that statement. Could you please elaborate on where
exactly it needs to be added?
The purpose of this reconstruction DDL is to generate the DDL for an
already created policy. The command you mentioned is used to enable
row-level security on the table, which is a separate step.

>
> regards
> Marcos
>
>
>