Postgres Pro
Downloads
Home   >   mailing lists

Re: Can row level security policies also be implemented for views? - Mailing list pgsql-general

From Caleb Meredith
Subject Re: Can row level security policies also be implemented for views?
Date
Msg-id CABFpK631z6nnK2wuPsLZH7zGNsWx7bNLFG45KbW2DNiTVD_96Q@mail.gmail.com
Whole thread Raw
In response to Re: Can row level security policies also be implemented for views?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Can row level security policies also be implemented for views?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general
Tree view
Yes it probably could be solved by this. Just a trigger which replaces SELECT right?
On Wed, Dec 2, 2015 at 6:01 PM Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
On 12/2/15 4:59 PM, Caleb Meredith wrote:
> What is an SRF?

Set returning function.

CREATE FUNCTION srf() RETURNS SETOF pg_class LANGUAGE sql AS 'SELECT *
FROM pg_class';
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-general by date:

Previous
From: Nguyễn Trần Quốc Vinh
Date:
Subject: Re: fast refresh materialized view
Next
From: John R Pierce
Date:
Subject: Re: Pgbasebackup help