Re: Question about RLS policy

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Garry Chen *EXTERN*'" <gc92(at)cornell(dot)edu>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Question about RLS policy
Date: 2017-06-07 15:40:44
Message-ID: A737B7A37273E048B164557ADEF4A58B53A56AD5@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Albe Laurenz 2017-06-09 06:57:43 Re: Question about RLS policy
Previous Message Garry Chen 2017-06-07 15:21:04 Question about RLS policy