Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goOvy-0000pH-1V for pgsql-admin@arkaria.postgresql.org; Tue, 29 Jan 2019 08:39:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1goOvw-0001ld-NO for pgsql-admin@arkaria.postgresql.org; Tue, 29 Jan 2019 08:39:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goOvw-0001lV-GL for pgsql-admin@lists.postgresql.org; Tue, 29 Jan 2019 08:39:52 +0000 Received: from mout.kundenserver.de ([212.227.126.135]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goOvt-0005Na-NX for pgsql-admin@lists.postgresql.org; Tue, 29 Jan 2019 08:39:52 +0000 Received: from [10.8.0.101] ([185.40.248.10]) by mrelayeu.kundenserver.de (mreue009 [212.227.15.129]) with ESMTPSA (Nemesis) id 1MBDva-1h16Fu0fdO-00Ckzr for ; Tue, 29 Jan 2019 09:39:48 +0100 Subject: Re: : : How to mask column: : To: pgsql-admin@lists.postgresql.org References: From: Thomas Kellerer Message-ID: <8a65c3aa-5059-d660-5d8c-523df82e7ea4@gmx.net> Date: Tue, 29 Jan 2019 09:39:47 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K1:Q87ksZkExJ8p2i+bKWmJ/nF9l7akTZiyBMjAlyU0ASK2RqDgEiV yAtPM9D5YU6EJNmFpn6BbIIZrcpJIIT6A9Cib+2ml3O1wzA7/1doI5oKb7r3Pq3CSbzJPsA rCIOJnhs642fNbJ+yTaSnt3xeRUWM7ueBT9y8sL4xQvSXin/TZ66cMV6ztWApzh8wEbIgJd 8pr3jPRAq7EHrs5ckD+jg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:+dwRgVWKGys=:KFYFFoXhOblvSVKbsI608b UkDlz67T6INKwZ2YeU78h5IxeZ5y6tB4ndGmzhktjgS9QQ75Ci3NW4aZfZD72NiZObUhw0SHj g7kepOTx3b3/J7GYJrb6arIXAnA6JJEysMh0kBTaKSaV+ODWg5wpIA4ythW1eFqhuUBdJEMV6 6tu+FkFhchSl47aovtVT7QFCTMbTDK+BodD1oQPBcR3ISpmcorqvRN/5UAvdHj0t1pi5jXwQ5 86zxvS4a1RjSvOnW0KXcXqq1DEBpdEPJAgTGhr5xmbSLcoDeerBDD8q9AFI9/XH4zI0t8+p5a rv9VtzjBCJW/OtEoH+fOP+bAaYCKu4VtdV6eRcR1i2wwFrBIfF7P/y2d3YsE3anEmtBcYbTui 0jmUWdK/N01psCSeHAGFrA+nrINv5g5Af2bB6vcfGA8G31Wp6lQSnTt9Abh4PtvtD10sXdzf4 TkQo35W2mpwr336mvjDVBktzuCdHDbMUK7uwmeGW2keUeSAIOX1jW5CvOqW3oYZbjj7PvtqZ9 misnByN0/MhePZo+MHMFG5h58nj0/xUrJvgrofHtG3SDTTU+zBvri44plVgABMyI3RrfJOGgT hVOC83nV743FgecKtV25f1dlwBLQ1uCsmY3ryUfesZA+M/eqobALQZnSq2JIvhoPnyMsULIgK 12O58WhcVTlcBW76GG8rk0hWh5mkt34dwgDSVb8BMRzdes7ea9KtK7sB9k4p7I7ZQMIeBtwMW U1LE4ItMms81XoVsIzBkcNI7h146DSaSRq/0PTXdAQno3coAW7tjg1nlyec= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk JD schrieb am 29.01.2019 um 09:02: > Hi Team, > > Is there any way to mask the column value (*******) in postgresql?  You could create a view that does that and only give access to that view, rather than the underlying table.