{"id":11699,"date":"2018-09-13T15:01:25","date_gmt":"2018-09-13T13:01:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/"},"modified":"2023-07-20T08:36:55","modified_gmt":"2023-07-20T06:36:55","slug":"masking-data-with-postgresql","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/","title":{"rendered":"Masking Data With PostgreSQL"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

I was searching a tool for anonymizing data in a PostgreSQL database and I have tested the extension pg_anonymizer<\/a>.
\nPostgreSQL_anonymizer is a set of SQL functions that remove personally identifiable values from a PostgreSQL table and replace them with random-but-plausible values. The goal is to avoid any identification from the data record while remaining suitable for testing, data analysis and data processing.
\nIn this blog I am showing how this extension can be used. I am using a PostgreSQL 10 database.
\nThe first step is to install the extension pg_anonymizer. In my case I did it with with pgxn client<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
[postgres@pgserver2 ~]$ pgxn <\/code>install<\/code> postgresql_anonymizer --pg_config <\/code>\/u01\/app\/postgres\/product\/10\/db_1\/bin\/pg_config<\/code><\/div>\n
INFO: best version: postgresql_anonymizer 0.0.3<\/code><\/div>\n
INFO: saving <\/code>\/tmp\/tmpVf3psT\/postgresql_anonymizer-0<\/code>.0.3.zip<\/code><\/div>\n
INFO: unpacking: <\/code>\/tmp\/tmpVf3psT\/postgresql_anonymizer-0<\/code>.0.3.zip<\/code><\/div>\n
INFO: building extension<\/code><\/div>\n
gmake: Nothing to be <\/code>done<\/code> for<\/code> `all'.<\/code><\/div>\n
INFO: installing extension<\/code><\/div>\n
\/usr\/bin\/mkdir<\/code> -p <\/code>'\/u01\/app\/postgres\/product\/10\/db_1\/share\/extension'<\/code><\/div>\n
\/usr\/bin\/mkdir<\/code> -p <\/code>'\/u01\/app\/postgres\/product\/10\/db_1\/share\/extension\/anon'<\/code><\/div>\n
\/usr\/bin\/install<\/code> -c -m 644 .<\/code>\/\/anon<\/code>.control <\/code>'\/u01\/app\/postgres\/product\/10\/db_1\/share\/extension\/'<\/code><\/div>\n
\/usr\/bin\/install<\/code> -c -m 644 .<\/code>\/\/anon\/anon--0<\/code>.0.3.sql\u00a0 <\/code>'\/u01\/app\/postgres\/product\/10\/db_1\/share\/extension\/anon\/'<\/code><\/div>\n
[postgres@pgserver2 ~]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can then verify that under \/u01\/app\/postgres\/product\/10\/db_1\/share\/extension we have a file anon.control and a directory named anon<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
[postgres@pgserver2 extension]$ <\/code>ls<\/code> -ltra anon*<\/code><\/div>\n
-rw-r--r--. 1 postgres postgres 167 Sep 13 10:54 anon.control<\/code><\/div>\n
<\/div>\n
anon:<\/code><\/div>\n
total 18552<\/code><\/div>\n
drwxrwxr-x. 3 postgres postgres\u00a0\u00a0\u00a0 12288 Sep 13 10:54 ..<\/code><\/div>\n
drwxrwxr-x. 2 postgres postgres\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 28 Sep 13 10:54 .<\/code><\/div>\n
-rw-r--r--. 1 postgres postgres 18980156 Sep 13 10:54 anon--0.0.3.sql<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Let\u2019s create a database named prod and let\u2019s create the required extensions. tsm_system_rows should delivered by the contrib.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n<\/td>\n
\n
\n
prod=# c prod<\/code><\/div>\n
You are now connected <\/code>to<\/code> database<\/code> \"prod\"<\/code> as<\/code> user<\/code> \"postgres\"<\/code>.<\/code><\/div>\n
prod=#<\/code><\/div>\n
prod=# <\/code>CREATE<\/code> EXTENSION tsm_system_rows;;<\/code><\/div>\n
CREATE<\/code> EXTENSION<\/code><\/div>\n
prod=#<\/code><\/div>\n
<\/div>\n
prod=# <\/code>CREATE<\/code> EXTENSION anon;<\/code><\/div>\n
CREATE<\/code> EXTENSION<\/code><\/div>\n
prod=#<\/code><\/div>\n
<\/div>\n
<\/div>\n
prod=# dx<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>List <\/code>of<\/code> installed extensions<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Name<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Version |\u00a0\u00a0 <\/code>Schema<\/code>\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Description<\/code><\/div>\n
<\/div>\n
-----------------+---------+------------+----------------------------------------------------<\/code><\/div>\n
--------<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 0.0.3\u00a0\u00a0 | anon\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Data anonymization tools<\/code><\/div>\n
\u00a0<\/code>plpgsql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 1.0\u00a0\u00a0\u00a0\u00a0 | pg_catalog | PL\/pgSQL procedural language<\/code><\/div>\n
\u00a0<\/code>tsm_system_rows | 1.0\u00a0\u00a0\u00a0\u00a0 | <\/code>public<\/code>\u00a0\u00a0\u00a0\u00a0 | TABLESAMPLE method which accepts number <\/code>of<\/code> rows<\/code> as<\/code><\/div>\n
a limit<\/code><\/div>\n
(3 <\/code>rows<\/code>)<\/code><\/div>\n
<\/div>\n
prod=#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The extension will create following functions in the schema anon. These functions can be used to mask some data.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n<\/td>\n
\n
\n
prod=# <\/code>set<\/code> search_path=anon;<\/code><\/div>\n
SET<\/code><\/div>\n
prod=# df<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>List <\/code>of<\/code> functions<\/code><\/div>\n
\u00a0<\/code>Schema<\/code> |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>Name<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0 Result data type\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Argu<\/code><\/div>\n
ment data types\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0 Type<\/code><\/div>\n
--------+--------------------------+--------------------------+------------------------------<\/code><\/div>\n
------------------------------------------+--------<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_city\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_city_in_country\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | country_name text<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_company\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_country\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_date\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | <\/code>timestamp<\/code> with<\/code> time<\/code> zone |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_date_between\u00a0\u00a0\u00a0\u00a0\u00a0 | <\/code>timestamp<\/code> with<\/code> time<\/code> zone | date_start <\/code>timestamp<\/code> with<\/code> tim<\/code><\/div>\n
e zone, date_end <\/code>timestamp<\/code> with<\/code> time<\/code> zone | normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_email\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_first_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_iban\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_int_between\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | <\/code>integer<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | int_start <\/code>integer<\/code>, int_stop <\/code>integer<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_last_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_phone\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | phone_prefix text <\/code>DEFAULT<\/code> '0'<\/code>::text<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_region\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_region_in_country | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | country_name text<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_siren\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_siret\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_string\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | l <\/code>integer<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
\u00a0<\/code>anon\u00a0\u00a0 | random_zip\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>| normal<\/code><\/div>\n
(18 <\/code>rows<\/code>)<\/code><\/div>\n
<\/div>\n
prod=#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now in the database prod let\u2019s create a table with some data.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n<\/td>\n
\n
\n
prod=# d customers<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Table<\/code> \"public.customers\"<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>Column<\/code>\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Type\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Collation | Nullable | <\/code>Default<\/code><\/div>\n
------------+-----------------------+-----------+----------+---------<\/code><\/div>\n
\u00a0<\/code>first_name | <\/code>character<\/code> varying<\/code>(30) |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0<\/code>last_name\u00a0 | <\/code>character<\/code> varying<\/code>(30) |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0<\/code>email_add\u00a0 | <\/code>character<\/code> varying<\/code>(30) |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0<\/code>country\u00a0\u00a0\u00a0 | <\/code>character<\/code> varying<\/code>(60) |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0<\/code>iban\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | <\/code>character<\/code> varying<\/code>(60) |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
\u00a0<\/code>amount\u00a0\u00a0\u00a0\u00a0 | <\/code>integer<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
<\/div>\n
prod=#<\/code><\/div>\n
<\/div>\n
prod=# <\/code>table<\/code> customers;<\/code><\/div>\n
\u00a0<\/code>first_name | last_name |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 email_add\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0 country\u00a0\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 iban\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0 amount<\/code><\/div>\n
------------+-----------+-------------------------+--------------+----------------------------+------------<\/code><\/div>\n
\u00a0<\/code>Michel\u00a0\u00a0\u00a0\u00a0 | Delco\u00a0\u00a0\u00a0\u00a0 | michel.delco@yaaa.fr\u00a0\u00a0\u00a0 | FRANCE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | FR763000600001123456890189 |\u00a0\u00a0\u00a0 5000000<\/code><\/div>\n
\u00a0<\/code>Denise\u00a0\u00a0\u00a0\u00a0 | Blanchot\u00a0 | denise.blanchot@yaaa.de | GERMANY\u00a0\u00a0\u00a0\u00a0\u00a0 | DE91100000000123456789\u00a0\u00a0\u00a0\u00a0 | 1000000000<\/code><\/div>\n
\u00a0<\/code>Farid\u00a0\u00a0\u00a0\u00a0\u00a0 | Dim\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | farid.dim@yaaa.sa\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Saudi Arabia | SA4420000001234567891234\u00a0\u00a0 |\u00a0\u00a0\u00a0 2500000<\/code><\/div>\n
(3 <\/code>rows<\/code>)<\/code><\/div>\n
<\/div>\n
prod=#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Let\u2019s say that I want some people to access to all data for this table, but I don\u2019t want them to see the real email, the real country and the real iban of the customers.
\nOne solution should be to create a view with anonymous data for these columns. This will replace them with random-but-plausible values for these columns<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
prod=# <\/code>create<\/code> view<\/code> Customers_anon <\/code>as<\/code> select<\/code> first_name <\/code>as<\/code> Firstname ,last_name\u00a0 <\/code>as<\/code> Lastnmame,anon.random_email() <\/code>as<\/code> Email ,anon.random_country() <\/code>as<\/code> Country, anon.random_iban() <\/code>as<\/code> Iban ,amount <\/code>as<\/code> Amount <\/code>from<\/code> customers;<\/code><\/div>\n
CREATE<\/code> VIEW<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And then grant the access privilege to concerned people<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
prod=# <\/code>select<\/code> * <\/code>from<\/code> customers_anon ;<\/code><\/div>\n
\u00a0<\/code>firstname | lastnmame |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 email\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | country |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 iban\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0\u00a0 amount<\/code><\/div>\n
-----------+-----------+-------------------------------+---------+----------------------------+------------<\/code><\/div>\n
\u00a0<\/code>Michel\u00a0\u00a0\u00a0 | Delco\u00a0\u00a0\u00a0\u00a0 | wlothean0@springer.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Spain\u00a0\u00a0 |\u00a0 AD1111112222C3C3C3C3C3C3\u00a0 |\u00a0\u00a0\u00a0 5000000<\/code><\/div>\n
\u00a0<\/code>Denise\u00a0\u00a0\u00a0 | Blanchot\u00a0 | emoraloy@dropbox.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | Myanmar |\u00a0 AD1111112222C3C3C3C3C3C3\u00a0 | 1000000000<\/code><\/div>\n
\u00a0<\/code>Farid\u00a0\u00a0\u00a0\u00a0 | Dim\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | vbritlandkt@deliciousdays.com | India\u00a0\u00a0 |\u00a0 AD1111112222C3C3C3C3C3C3\u00a0 |\u00a0\u00a0\u00a0 2500000<\/code><\/div>\n
(3 <\/code>rows<\/code>)<\/code><\/div>\n
<\/div>\n
prod=#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Thanks to Damien for this project. Just not that this project is in its early development and should be used with care (see Damien comment below).<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw I was searching a tool for anonymizing data in a PostgreSQL database and I have tested the extension pg_anonymizer. PostgreSQL_anonymizer is a set of SQL functions that remove personally identifiable values from a PostgreSQL table and replace them with random-but-plausible values. The goal is to avoid any identification from the data record […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[83],"tags":[],"type_dbi":[],"class_list":["post-11699","post","type-post","status-publish","format-standard","hentry","category-postgresql"],"acf":[],"yoast_head":"\nMasking Data With PostgreSQL - dbi Blog<\/title>\n<meta name=\"description\" content=\"PostgreSQL, data masking, pg_anonymizer,security\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Masking Data With PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL, data masking, pg_anonymizer,security\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-13T13:01:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-20T06:36:55+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Masking Data With PostgreSQL\",\"datePublished\":\"2018-09-13T13:01:25+00:00\",\"dateModified\":\"2023-07-20T06:36:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/\"},\"wordCount\":283,\"commentCount\":0,\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/\",\"name\":\"Masking Data With PostgreSQL - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-09-13T13:01:25+00:00\",\"dateModified\":\"2023-07-20T06:36:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"PostgreSQL, data masking, pg_anonymizer,security\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Masking Data With PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Masking Data With PostgreSQL - dbi Blog","description":"PostgreSQL, data masking, pg_anonymizer,security","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"Masking Data With PostgreSQL","og_description":"PostgreSQL, data masking, pg_anonymizer,security","og_url":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/","og_site_name":"dbi Blog","article_published_time":"2018-09-13T13:01:25+00:00","article_modified_time":"2023-07-20T06:36:55+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Masking Data With PostgreSQL","datePublished":"2018-09-13T13:01:25+00:00","dateModified":"2023-07-20T06:36:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/"},"wordCount":283,"commentCount":0,"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/","url":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/","name":"Masking Data With PostgreSQL - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-09-13T13:01:25+00:00","dateModified":"2023-07-20T06:36:55+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"PostgreSQL, data masking, pg_anonymizer,security","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/masking-data-with-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Masking Data With PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11699"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11699\/revisions"}],"predecessor-version":[{"id":25783,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11699\/revisions\/25783"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11699"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11699"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}