CAST(date_part('epoch', nodes.date_created) AS bigint) AS date_created,
CAST(date_part('epoch', nodes.last_updated) AS bigint) AS last_updated,
CAST(date_part('epoch', nodes.last_contact) AS bigint) AS last_contact,
-CAST(date_part('epoch', nodes.last_boot) AS bigint) AS last_boot,
CAST(date_part('epoch', nodes.last_download) AS bigint) AS last_download,
CAST(date_part('epoch', nodes.last_pcu_reboot) AS bigint) AS last_pcu_reboot,
CAST(date_part('epoch', nodes.last_pcu_confirmation) AS bigint) AS last_pcu_confirmation,
FROM conf_files;
--------------------------------------------------------------------------------
-DROP VIEW view_pcus;
CREATE OR REPLACE VIEW view_pcus AS
SELECT
pcus.pcu_id,