PowerDNS

select trim(concat(name,':',type,':',content)) from records;