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

On 10/04/2010 12:59 PM, Wang, Mary Y wrote:
> 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
>
>
>
>
>

As sql COPY"
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html
In psql \copy
http://www.postgresql.org/docs/8.3/interactive/app-psql.html

COPY is done from the standpoint of the server so the file location must
be accessible to the server.

\copy is done from the standpoint of the client.
--
Adrian Klaver
adrian.klaver@gmail.com