Please Note: The steps described in this article today(04/28/2019) refers to EDB Postgres Replication Server 7.x BETA. Expect some of the steps may change in GA or future releases. Recommended to refer to latest documentation here
Watch steps-covering video: https://www.youtube.com/watch?v=NPSgtzrU7VU
Most of us know EnterpriseDB has a software package for cross database Multi-Master Replication(MMR) or Single-Master Replication(SMR) servers that supports an asynchronous replication system to replicate data to EDB Postgres Advanced Server(EPAS) and PostgreSQL.
In this post, we see how to validate the JSON/JSONB data type column in PostgreSQL 10. Most of the basic JSON/JSONB validation has been taken care in core of PostgreSQL itself, however you may have a requirement to validate the JSON format elements data types while inserting. For such requirements, you need to write a Pl/PgSQL function to validate the JSON data when accepting it in JSON/JSONB column in a CHECK constraint.