CODE EXAMPLE FOR SQL

dump heroku database to sql

heroku pg:backups:capture 
heroku pg:backups:download

pg_restore -f sqldump.sql latest.dump

Ilya Petrov