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...
