Geo-partitioning helper functions
Contribute
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 |