↑↓ 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

text

Read the PG 18 manual

Returns the unabbreviated IP address and netmask length as text.

Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

text ( inet ) → text
Returns the unabbreviated IP address and netmask length as text. (This has the same result as an explicit cast to text.)
text(inet '192.168.1.5') → 192.168.1.5/32
Version history 2
  1. 12 → 13 changed
  2. 7.3 → 7.4 changed

Definition snapshot: b7bd9cda · English manual source