|
Hi All Thank you for the responses so far... I do however have a more specific question regarding this
data dump that I need to create for them. From what I can see in the specs and current output files,
the client needs the data output in .xml format in order to use this on their
side, still trying to understand why though... Is there a method of outputting / dumping the data into
.xml format as part of the scripts / crons/ db processes? Machiel Richards MySQL DBA Email: machielr@xxxxxxxxx Tel: 0861 732 732
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Ralf Schuchardt 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 |
