Import heroku database

gistfile1.txt

heroku pg:backups capture --app sushi
curl -o latest.dump `heroku pg:backups public-url --app sushi`
pg_restore --verbose --clean --no-acl --no-owner -j 8 [-U user_name] -d database_name latest.dump

# To copy prodcution data to staging app
heroku pg:backups restore `heroku pgbackups:url -a production-app` DATABASE -a staging-app

# Store prodcution data to staging
heroku pg:backups restore `heroku pgbackups:url -a production-app` DATABASE -a staging-app
heroku pg:backups restore b001 DATABASE_URL --app sushi

heroku pg:copy DATABASE_URL HEROKU_POSTGRESQL_PINK_URL --app sushi

dropdb database
createdb --owner=user database

psql --dbname=database
create extension cube;
create extension earthdistance;
create extension intarray;
CREATE EXTENSION IF NOT EXISTS pg_trgm