↑↓ select↵ open⌫ change scopeOpen full search

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

Wiki / Functions

text

Returns the unabbreviated IP address and netmask length as text. (This has the same result as an explicit cast to text.)

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 unabbreviated IP address and netmask length as text. (This has the same result as an explicit cast to text.)

Signatures and overloads

text ( inet ) → text → text
Returns the unabbreviated IP address and netmask length as text. (This has the same result as an explicit cast to text.)

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:bfcdd2797b293b5031fb0af0972d6f0a6a1bbb9e1fc4966d0a2aee4d57292455

Text language: en · wiki-repair-20261023:bfcdd2797b293b5031fb0af0972d6f0a6a1bbb9e1fc4966d0a2aee4d57292455