Postgresql: find next available IP addresses

November 5, 2011

Postgresql has the inet and cidr datatypes and some great functions for these types, very useful for storing and manipulating data for IP addresses and networks. As a basic example, say you were storing hostnames and IP addresses, basic example table below: id ip_address hostname 1 10.10.100.15 server01 If I… [...]