Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY command character set - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY command character set
Date
Msg-id 12808.1252548826@sss.pgh.pa.us
Whole thread Raw
In response to COPY command character set  ("Peter Headland" <pheadland@actuate.com>)
Responses Re: COPY command character set  ("Peter Headland" <pheadland@actuate.com>)
List pgsql-general
Tree view 
"Peter Headland" <pheadland@actuate.com> writes:
> The documentation of the COPY command does not state what character
> set(s) are recognized or written. I need to import and export UTF-8
> data; how can I do that?

set client_encoding = 'utf8';
copy from stdin/to stdout;

            regards, tom lane

pgsql-general by date:

Previous
From: "Peter Headland"
Date:
Subject: COPY command character set
Next
From: "Andrus"
Date:
Subject: Re: pg_dump exists without any message when running from windows task scheduler