help - Mailing list pgsql-general

From Elizabeth George
Subject help
Date
Msg-id 4E3524B7F7154D4D93ABCF5E2471224FC544@dc-india.telesindia.com
Whole thread Raw
Responses Re: help  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general

Hi  

  I am trying to execute the query

 

 

SET CLIENT_ENCODING TO 'UNICODE';

copy (select 1 as F1) to E'c:\\test.out' csv QUOTE AS E'\xFE' FORCE QUOTE F1;

 

 I got error like

 

ERROR:  invalid byte sequence for encoding "UTF8": 0xfe

HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".

 

 

Client encoding is Unicode and the server encoding is UTF8

 

pls help

 

Regards

             Elizabeth K George

 

 

pgsql-general by date:

Previous
From: Mathias Ghys
Date:
Subject: problem with importing dbf file into postgresql using navicat on mac OS X
Next
From: "IVO GELOV"
Date:
Subject: Strange behaviour - performance decreases after each TRUNCATE