Quick Links

How to data dump a table content to a CSV or XML format?

From:	"Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To:	"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject:	How to data dump a table content to a CSV or XML format?
Date:	2010-10-04 19:59:51
Message-ID:	FA20D4C4FEBFD148B1C0CB09913825FC05698BE1B3@XCH-SW-06V.sw.nos.boeing.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi All,

I'd like to do a data dump of a table to a CSV or XML file.
How would I do that?

I'm running on Postgres 8.3.8.

Thanks in advance.
Mary Wang

Responses

Re: How to data dump a table content to a CSV or XML format? at 2010-10-04 20:21:00 from Dann Corbit
Re: How to data dump a table content to a CSV or XML format? at 2010-10-04 20:23:32 from Adrian Klaver
Re: How to data dump a table content to a CSV or XML format? at 2010-10-04 23:35:28 from Ben Madin

Browse pgsql-general by date

	From	Date	Subject
Next Message	Sairam Krishnamurthy	2010-10-04 20:02:07	Having two simultaneous and similar database
Previous Message	andrew harvey	2010-10-04 19:51:11	Record Separator with psql -c when output to a variable not a file!