PostgreSQL Dump [Docker]

dump.sh

 # dump from docker
 docker exec dbname dockerinstance -d postgres -Fc -U postgres > dump.sql
 
 # finding dump encoding
 file dump.sql
 
 # Output> dump.sql: Little-endian UTF-16 Unicode text, with very long lines, with CRLF line terminators
 
 # convert it to utf-8
 iconv -f utf-16 -t utf-8 dumb.sql > dumb-utf8.sql
 
 # restore the db
 cat .\dump.sql | docker exec -i dockerinstance psql dbname -U db_user