[Python] How to export data from a .pgsql file to .csv (or similar)

I have a .pgsql file locally and I would like to export various data inside of it into a CSV format so that I can process it further. I tried to use psql but it keeps asking for username and password. This is a locally generated file and as far as I know, there is no username/password for it.

My end goal is to convert the .pgsql file contents to .csv format in python for further processing. I am trying this on Mac. Appreciate any inputs on these two questions.

Continue reading...