I had a situation where I had to get a dump of postgresql database. I tried pg_dump but the output was required in csv. I got stuck and went over to stackoverflow for rescue. From there I got a working script.
But there was a slight problem. I didn’t know what the schema table was for my database tables. Again after searching for a long time found hints to commands that could provide me with the schema name.
From the result, you can find the schema name. After that you send the rest to the script.
script.sh
There is only a slight difference between the script I got from stackoverflow. I just added HEADER to the script so that every csv file generated will have a header. To get the files run
]$ sh script.sh
All csv will be generated in the same directory as that of script.sh
Once all the csv are generated, I can simply run an scp command to get all of them to my local system or better yet compress them from server and use scp.
Server access is definitely necessary for this though (although I know that everyone already knows :D). Hope this is helpful.