Through the Heroku PostgreSQL add-on create a new backup capture you can do that by the UI or the CLI running:

heroku pg:backups:capture -a your-production-name-app

and after that run:

heroku pg:backups:restore <production-database-name>::<you-backups-id> DATABASE_URL --app <production-staging-enviroment> --confirm <production-staging-enviroment>

example:

heroku pg:backups:restore juanequex-prod::b194 DATABASE_URL --app juanequex-staging --confirm juanequex-staging

Enjoy! c:

The Heroku CLI offers numerous benefits, including the ability to directly check how many apps are in your account using this command:

heroku apps

If you want to verify the most critical information about a specific app, you can use this command: 

heroku apps:info --app example

FYI is important that you log login before.