Re: COPY command character set

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Headland" <pheadland(at)actuate(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY command character set
Date: 2009-09-10 02:13:46
Message-ID: 12808.1252548826@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Peter Headland" <pheadland(at)actuate(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2009-09-10 06:34:53 Re: pg_dump exists without any message when running from windows task scheduler
Previous Message Peter Headland 2009-09-10 01:14:12 COPY command character set