↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

host

Returns the IP address as text, ignoring the netmask.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

group
net
group label
Network Address Functions And Operators
lang
en
layout
table-new
pages
functions-net.html
prose only
false

Definition PG 18

Returns the IP address as text, ignoring the netmask.

Signatures and overloads

host ( inet ) → text → text
Returns the IP address as text, ignoring the netmask.

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:61ba1bb628e4e58cea03cbd32f1c32e7360fe9577683a800386944debef44e55

Text language: en · wiki-repair-20261023:61ba1bb628e4e58cea03cbd32f1c32e7360fe9577683a800386944debef44e55