CREATE TABLE table_cidr_type (id varchar NOT NULL, col_cidr cidr, CONSTRAINT table_cidr_type_pkey PRIMARY KEY (id)); CREATE TABLE table_macaddr_type (id varchar NOT NULL, col_macaddr macaddr, CONSTRAINT table_macaddr_type_pkey PRIMARY KEY (id)); CREATE TABLE table_macaddr8_type (id varchar NOT NULL, col_macaddr8 macaddr8, CONSTRAINT table_macaddr8_type_pkey PRIMARY KEY (id)); INSERT INTO table_cidr_type (id, col_cidr) VALUES('1', '2.0.0.0/8'::cidr); INSERT INTO table_macaddr_type (id, col_macaddr) VALUES('1', '08:00:2b:01:02:04'::macaddr); INSERT INTO table_macaddr8_type (id, col_macaddr8) VALUES('1', '08:00:2b:ff:fe:01:02:05'::macaddr8);