cast bytea to macaddr

[Matt Zagrabelny <mzagrabe@xxxxxxxxx>]

Greetings Pg folks,

I have a database schema (not mine) that uses bytea to represent a MAC address. I'd like to create a view that casts that field into a MACADDR type.

# \d lease4
                           Table "public.lease4"
     Column     │           Type           │ Collation │ Nullable │ Default
════════════════╪══════════════════════════╪═══════════╪══════════╪═════════
 hwaddr         │ bytea                    │           │          │

# select hwaddr from lease4;
     hwaddr    
════════════════
 \x9cebe803e3b9

It looks like I can cast the bytea to text and then manipulate that and finally cast it to macaddr.

Is there a better, or more canonical, way to convert/cast this field?

Thanks for any help!

-m