| PostgreSQL Reference Manual - Volume 1 - SQL Language Reference by The PostgreSQL Global Development Group Paperback (6"x9"), 716 pages ISBN 0954612027 RRP £32.00 ($49.95) Sales of this book support the PostgreSQL project! Get a printed copy>>> |
6.8 Network Address Types
PostgreSQL offers data types to store IPv4, IPv6, and MAC addresses, as shown in Table 6-17. It is preferable to use these types instead of plain text types to store network addresses, because these types offer input error checking and several specialized operators and functions (see section 7.11 Network Address Functions and Operators).
Table 6-17: Network Address Types
| Name | Storage Size | Description
|
cidr | 12 or 24 bytes | IPv4 and IPv6 networks
|
inet | 12 or 24 bytes | IPv4 and IPv6 hosts and networks
|
macaddr | 6 bytes | MAC addresses |
When sorting inet or cidr data types,
IPv4 addresses will always sort before IPv6 addresses, including
IPv4 addresses encapsulated or mapped into IPv6 addresses, such as
::10.2.3.4 or ::ffff::10.4.3.2.
| ISBN 0954612027 | PostgreSQL Reference Manual - Volume 1 - SQL Language Reference | See the print edition |