Hello, I get the following error when running a sql script containing a COPY command:
ERROR: invalid byte sequence for encoding "UTF8": 0xff 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". What I have done is write a perl script that selects out certain data from a database and places it tab separated output between a line with COPY from stdin and .\. Just like the pg_dump output looks. The data I have contains binary data from a tcp dump. After running my perl script I put the result through this command, to escape the octets. (thought i needed to do this) cat data.dump | iconv -c -f utf8 -t utf8 > fixed.dump Does anybody know how the dump pulls a column with binary data? It is a varchar column. -chris worley -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
