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
