Re[2]: Possible solution for masking chosen columns when using pg_dump

2022-10-10 Thread Олег Целебровский
name), >>* name of masking function and name of schema containing this function >>(public if not specified) >>*/ >the name of its table >    >пн, 3 окт. 2022 г. в 20:45, Julien Rouhaud < rjuju...@gmail.com >: >>Hi, >> >>On Mon, Oct 03, 2022 at 06:

Possible solution for masking chosen columns when using pg_dump

2022-10-03 Thread Олег Целебровский
Hello, here's my take on masking data when using pg_dump   The main idea is using PostgreSQL functions to replace data during a SELECT. When table data is dumped SELECT a,b,c,d ... from ... query is generated, the columns that are marked for masking are replaced with result of functions on those