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

From: Dann Corbit <DCorbit(at)connx(dot)com>
To: "'Wang, Mary Y'" <mary(dot)y(dot)wang(at)boeing(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to data dump a table content to a CSV or XML format?
Date: 2010-10-04 20:21:00
Message-ID: 87F42982BF2B434F831FCEF4C45FC33E4201F9AD@EXCHANGE.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Wang, Mary Y
> Sent: Monday, October 04, 2010 1:00 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] How to data dump a table content to a CSV or XML
> format?
>
> 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.
>
Did you see this:
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-10-04 20:23:32 Re: How to data dump a table content to a CSV or XML format?
Previous Message Sairam Krishnamurthy 2010-10-04 20:02:07 Having two simultaneous and similar database