PostgreSQL Reference Manual - Volume 1 - SQL Language Reference by The PostgreSQL Global Development Group Paperback (6"x9"), 716 pages ISBN 0954612027 RRP £32.00 ($49.95) Sales of this book support the PostgreSQL project! Get a printed copy>>>

PostgreSQL Reference Manual Volume 1 Buy the book here! >>> learn more

6.8.4 macaddr

The macaddr type stores MAC addresses, i.e., Ethernet card hardware addresses (although MAC addresses are used for other purposes as well). Input is accepted in various customary formats, including

• '08002b:010203'
• '08002b-010203'
• '0800.2b01.0203'
• '08-00-2b-01-02-03'
• '08:00:2b:01:02:03'

which would all specify the same address. Upper and lower case is accepted for the digits a through f. Output is always in the last of the forms shown.