Re: Data dumps to files - best methods?

Thank you very much, I think this will help a lot.

Will ask for more details once I receive the full specs,etc...

Machiel Richards

MySQL DBA

Email: machielr(at)rdc(dot)co(dot)za

Tel: 0861 732 732

RDC_Logo

From: Ralf Schuchardt [mailto:rasc(at)gmx(dot)de]
Sent: 23 July 2010 01:37 PM
To: Machiel Richards
Cc: pgsql-general(at)postgresql(dot)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 <smb://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