Sunday, 2 August 2015

Postgres output to CSV with special characters

\copying a table to csv and you want to open in Excel, specifying
WITH(format csv, encoding 'latin1', header true)

results in correct special characters. 
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)