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

----------------původní zpráva-----------------
Od: Gordon Ross [[email protected] ]
Komu: [email protected]
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 [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