↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / NETWORK ADDRESS FUNCTIONS AND OPERATORS

host

Read PG 18 manual ↗

Returns the IP address as text, ignoring the netmask.

Signatures & examples

host ( inet ) → text
Returns the IP address as text, ignoring the netmask.
host(inet '192.168.1.0/24') → 192.168.1.0
Version history 1
  1. PG 12 → 13changed

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source