Invalid byte sequence for encoding “UTF8”: 0xf8

psql=# \copy mytable(id,name,age,location) from '/path/to/file.csv' with delimiter ',' csv header encoding 'windows-1251';

--

--

--

System Administrator and Full stack web developer.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

FujiDAO now aggregates Fuse pools

[Embedded System] Internal Sensor Project

Building A Blockchain Application In 10 Hours

NodeOS: The JavaScript Based Operating System

Hi all

How FLEXable can you be?

Top 10 programming language that has a scope in future

App Localization Tips With Swift

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Himanshu Pratap

Himanshu Pratap

System Administrator and Full stack web developer.

More from Medium

How to setup ELK Stack

Rabbit MQ Consume message as batch

Restoring a Failed member in InnoDB Cluster

Setup Kafka for Windows in 2 Mins