Geo-partitioning helper functions
Synopsis
The following functions are primarily helpful while implementing Row-level geo-partitioning, as they can significantly simplify inserting rows from user's server and selecting rows from the local partition.
Function | Return Type | Description |
---|---|---|
yb_is_local_table(oid) | boolean | Returns whether the given 'oid' is a table replicated only in the local region |
yb_server_region() | varchar | Returns the region of the currently connected node |
yb_server_zone() | varchar | Returns the zone of the currently connected node |
yb_server_cloud() | varchar | Returns the cloud provider of the currently connected node |