Hi, Am 23.07.2010 um 10:32 schrieb Machiel Richards:
> As I am fairly new to postgresql I am trying to find some more info > regarding options to dump specific data to files. > However, even though I can get the sql query,etc... how will I use this > to dump the data into the relevant files? You can use the "\copy" command in psql to export the result of query into a file. For example: > psql -c "\\copy (select * from atable) to 'myfile.csv' with delimiter as ',' > csv header" adb will copy all rows from "atable" in "adb" to "myfile.csv" in csv format. Ralf
