INET type
Synopsis
Use the INET data type to specify columns for data of IP addresses.
Syntax
type_specification ::= INET
Semantics
- Columns of type
INETcan be part of thePRIMARY KEY. - Implicitly, values of type
INETdata types are neither convertible nor comparable to other data types. - Values of text data types with correct format are convertible to
INET. INETvalue format supports text literals for both IPv4 and IPv6 addresses.
Examples
example> CREATE TABLE dns_table(site_name TEXT PRIMARY KEY, ip_address INET);
example> INSERT INTO dns_table(site_name, ip_address) VALUES ('localhost', '127.0.0.1');
example> INSERT INTO dns_table(site_name, ip_address) VALUES ('example.com', '93.184.216.34');
INET type supports both ipv4 and ipv6 addresses.
example> UPDATE dns_table SET ip_address = '2606:2800:220:1:248:1893:25c8:1946' WHERE site_name = 'example.com';
example> SELECT * FROM dns_table;
site_name | ip_address
-------------+------------------------------------
example.com | 2606:2800:220:1:248:1893:25c8:1946
localhost | 127.0.0.1