Re: [GENERAL] problems with copy from file

2015-10-15 Thread Jim Nasby
On 10/14/15 11:40 AM, Andreas Kretschmer wrote: test=*# \copy httpd_log (data) from '~/test.log'; ERROR: invalid byte sequence for encoding "UTF8": 0xb1 CONTEXT: COPY httpd_log, line 3: "other-domain bb.243.xx.yyy - - [06/Nov/2014:00:48:22 +0100] "\x16\x03\x01\x01\xb1\x01" 501 10..." I don't

Re: [GENERAL] problems with copy

2001-02-24 Thread Doug McNaught
"Steff" <[EMAIL PROTECTED]> writes: > I'm starting using PostgreSQL and want to import datas from my old database. > I've made ASCII delimited files and want to use the copy instruction. > > Having the server started, I do the following : > > > psql mydb > >copy table from 'myfile' using delimi