Can anyone please help me on how to transfer data from Postgresql to Apache Pinot using Golang or through a Csv file stored locally?

You can follow this documentation on configuring a batch ingestion job where Pinot can import data from a CSV. The other way is to feed the CDC events to Pinot as a real-time stream via Kafka or any other streaming platform.