Is there a method of outputting / dumping the data into .xml format as part of the scripts / crons/ db processes?
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Ralf SchuchardtSent: 23 July 2010 01:37 PMTo: Machiel RichardsCc: pgsql-general@postgresql.orgSubject: Re: [GENERAL] Data dumps to files - best methods? 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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных