Re: Data dumps to files - best methods? - Mailing list pgsql-general
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@rdc.co.za
Tel: 0861 732 732
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Ralf Schuchardt
Sent: 23 July 2010 01:37 PM
To: Machiel Richards
Cc: pgsql-general@postgresql.org
Subject: 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
Attachment
pgsql-general by date: