Hello
How do i get past the error below. I have created a foreign table which points to a csv file and when i try to create another table it gives error below
The csv file has funny characters, how do i bypass those characters.
create foreign table table1
(
id int,
name text
)
SERVER local_file
OPTIONS (filename '/outputfile.csv' ,
format 'csv',
header 'TRUE',
delimiter ';'
);
create table2 as select * from table1;
ERROR: invalid byte sequence for encoding "UTF8": 0x00
CONTEXT: COPY table1, line 377617