How to generate file from postgres data

[Shubham Mittal]

Hi Team,

I want to execute some queries on postgres and generate the reports
containing the resultset on client side for user in the most efficient way.
The data can be of 1 gb also.

Could you please help.

Thanks and regards,
Shubham