Home / server / Questions / 224612
In Process
xain
Asked: 2011-01-21 03:08:59 +0800 CST

Accent problem when exporting postgresql database

  • 772

I'm exporting my postgresql db using the command

su - postgres -c "pg_dump --inserts --column-inserts mydb" > export.sql

But when I open the exported file with vi, the letter with accents are not being displayed correctly, however the web app that reads data from this DB does show them ok.

Any hints ? Thanks.

postgresql export

1 Answers

  1. It can either be due to

    • Your vi is not configured to support UTF-8 characters, try to add set fileencodings=utf-8,latin1 to your vimrc
    • Your pg_dump is not dumping as UTF-8, you can force it to do so by adding -E UTF8 to your pg_dump options
    • 1