yb_server_zone()

This page documents the preview version (v2.21). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.

Synopsis

yb_server_zone() returns the zone that a user's server is connected to.

Examples

Select the zone that you're connected to:

yugabyte=# SELECT yb_server_zone();

 yb_server_zone
-----------------
 us-west-1c
(1 row)

Usage in Row-level geo-partitioning

Similar to yb_server_region(), this function is also helpful while implementing Row-level geo-partitioning, as it can significantly simplify inserting rows from the user server's partition if the partitioning is based on default value of yb_server_zone().

Note

If you didn't set the placement_region flag at node startup, yb_server_region() returns NULL.

See also