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@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
