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.