Skip to content

Instantly share code, notes, and snippets.

@lucasdavila

lucasdavila/query_from_utf8_to_latin1.sh

Created November 21, 2012 21:25
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save lucasdavila/4127860 to your computer and use it in GitHub Desktop.
Save lucasdavila/4127860 to your computer and use it in GitHub Desktop.
Download ZIP
Simple postgresql script conversion from utf8 to latin1
Raw
query_from_utf8_to_latin1.sh
# first convert the utf-8 script to latin1
iconv -f utf-8 -t latin1 file.sql > __latin1-file.sql
# after execute the latin1 file
psql -d db-name -a -f __latin1-file.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment