Re: [NOVICE] Question about RLS policy - Mailing list pgsql-novice

From Albe Laurenz
Subject Re: [NOVICE] Question about RLS policy
Date
Msg-id A737B7A37273E048B164557ADEF4A58B53A56AD5@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to [NOVICE] Question about RLS policy  (Garry Chen <gc92@cornell.edu>)
List pgsql-novice
Garry Chen wrote:
> I am new to postgresql and try to create RLS for a table using policy.  I
> am wondering can I using plpgsql instated off sql inside using ()?

Not sure if I understand you right, but you must put SQL into the USING
and WITH CHECK clauses.

But you can call a PL/pgSQL function from that SQL.

Yours,
Laurenz Albe

pgsql-novice by date:

Previous
From: Garry Chen
Date:
Subject: [NOVICE] Question about RLS policy
Next
From: Albe Laurenz
Date:
Subject: Re: [NOVICE] Question about RLS policy