Create a quick report for a client
Since you mentioned your client wanted a comma separated file as a report, you could always do something like:

psql -U myuser -h my.rds.external.address -c "\copy (SELECT * FROM mytable WHERE foo = 'bar') TO 'my_report.csv' WITH CSV HEADER NULL AS ''"

If you run that from a command line or a cron job from another machine (once you've allowed that IP address in your RDS instance configuration), you can just compress it and make it available to your client based on their needs.

A view would also work if you wanted to give them realtime access to the data instead of a comma separated report.