Answers for "heroku pg:psql"

connect to db heroku

heroku pg:psql -f schema.sql -a HEROKU_APP_NAME

create heroku add on postgres

heroku addons:create heroku-postgresql:hobby-dev

how to find my postgres hostname heorku

heroku pg:credentials:url

heroku cli connect to postgres

$ PGUSER=postgres PGPASSWORD=password heroku pg:pull HEROKU_POSTGRESQL_MAGENTA mylocaldb --app sushi

local pg_sql to heroku pg_sql

# set the password in an environment variable
export PGPASSWORD=mypassword # linux/mac
set PGPASSWORD=mypassword # windows
# create the database dump
$ pg_dump -Fc --no-acl --no-owner -h localhost -U myuser mydb > mydb.dump