INET type

Synopsis

Use the INET data type to specify columns for data of IP addresses.

Syntax

type_specification ::= INET

Semantics

  • Columns of type INET can be part of the PRIMARY KEY.
  • Implicitly, values of type INET data types are neither convertible nor comparable to other data types.
  • Values of text data types with correct format are convertible to INET.
  • INET value 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

See also