Re: Extension vs Implementing Wire Protocol

2020-07-20 Thread Karsten Hilbert
On Mon, Jul 20, 2020 at 10:36:26PM +0200, Thomas Kellerer wrote: > > * 'SELECT * FROM table;' should return masked versions of the columns > > based on policy for that specific user. > > * 'SELECT * FROM table;' should return just the columns accessible to a  > > specific user. > > > > Questi

Re: Extension vs Implementing Wire Protocol

2020-07-20 Thread Thomas Kellerer
Matthew Tamayo-Rios schrieb am 20.07.2020 um 22:13: Examples of behaviors we'd like to have: * 'SELECT * FROM table;' should return masked versions of the columns based on policy for that specific user. * 'SELECT * FROM table;' should return just the columns accessible to a  specific user.

Extension vs Implementing Wire Protocol

2020-07-20 Thread Matthew Tamayo-Rios
Hi all, We need to apply some data management policies on read. We are considering two approaches 1. Implement a postgres extension. 2. Implement a proxy that implements the PostgreSQL wire protocol. We're trying to decide which approach to take and are leaning towards implementing it as a