Andreas,
Have you looked at using pgloader?
http://pgloader.projects.postgresql.orgAlso did you save the MS Office file as a simple plain text file?
I'm a novice myself but do know that this offers slightly more advanced options than the simple COPY utility.
On Thu, Nov 11, 2010 at 10:01 PM, Andreas
<maps.on@gmx.net> wrote:
Hi,
I'd like to import some data from ms-office that has text columns with international characters in it.
COPY complains about illegal byte sequences.
When I placed a "set client_encoding = LATIN1" in front of the COPY command, COPY was happy.
It still didn't work as expected. There were empty attributes in the imported table when there were accent decorated characters in the source file.
Is there a way to import UTF8 encoded csv files ?
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice