Looking for patterns for instantaneous data consistency for DB transactions that span multiple schemas in a Aurora postgres instance

We are currently developing a product in the AWS environment that requires instantaneous data consistency for DB transactions that span multiple schemas in a Aurora postgres instance. Each schema will be updated by a service/micro-service/lambda orchestrated through step function workflow.