[Kea-users] How to get HW address from postgresql database in traditional form i.e. 12 hexadecimal digits ?

[Bc. Luboš Malý]

Thank you Gordon. That is what I need.
L.

----------------původní zpráva-----------------
Od: Gordon Ross [gr306 at cam.ac.uk ]
Komu: kea-users at lists.isc.org
Datum: Mon, 05 Sep 2022 08:42:22 +0200
----------------------------------------------------------
>
>
> SELECT '0.0.0.0'::inet + address AS "IP Address” FROM lease4
>
> Gordon.
>
> From: Kea-users kea-users-bounces at lists.isc.org on behalf of Bc.  
> Luboš Malý maly at svkul.cz
> Date: Saturday, 3 September 2022 at 21:32
> To: kea-users at lists.isc.org kea-users at lists.isc.org Subject:  
> [Kea-users] How to get HW address from postgresql database in  
> traditional form i.e. 12 hexadecimal digits ?
> Hello Kea-users,
>
> is there any of you using postgresql as lease-database ? I'd like to  
> know how to use select command on lease-database and get HW address  
> stored in lease4 table in the form of traditional MAC i.e. 12  
> hexadecimal digits. When I try common select command I get the  
> address like this 3232261123.
>
> Thanks
>
> Regards
>
> Lubos
>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20220905/c7595581/attachment-0001.htm>