SELECT '0.0.0.0'::inet + address AS "IP Address” FROM lease4

Gordon.
From: Kea-users <[email protected]> on behalf of Bc. Luboš Malý 
<[email protected]>
Date: Saturday, 3 September 2022 at 21:32
To: [email protected] <[email protected]>
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
-- 
ISC funds the development of this software with paid support subscriptions. 
Contact us at https://www.isc.org/contact/ for more information.

To unsubscribe visit https://lists.isc.org/mailman/listinfo/kea-users.

Kea-users mailing list
[email protected]
https://lists.isc.org/mailman/listinfo/kea-users

Reply via email to