convert mac address to 64 bit host address

This type can accept both 6 and 8 byte length MAC addresses and stores them in 8 byte length format. The macaddr8 type stores MAC addresses in EUI-64 format, known for example from Ethernet card hardware addresses (although MAC addresses are used for other purposes as well). The remaining five input formats are not part of any standard. PostgreSQL makes no provisions for bit reversal all accepted formats use the canonical LSB order. This convention is widely ignored nowadays, and it is relevant only for obsolete network protocols (such as Token Ring). IEEE Standard 802-2001 specifies the second form shown (with hyphens) as the canonical form for MAC addresses, and specifies the first form (with colons) as used with bit-reversed, MSB-first notation, so that 08-00-2b-01-02-03 = 10:00:D4:80:40:C0. Output is always in the first of the forms shown. Upper and lower case is accepted for the digits a through f. These examples all specify the same address.

Input is accepted in the following formats: '08:00:2b:01:02:03'

The macaddr type stores MAC addresses, known for example from Ethernet card hardware addresses (although MAC addresses are used for other purposes as well).

Convert mac address to 64 bit host address