问题描述
当我在本地开发时，我会运行一个
When I am developing locally, I'll just run a
rails c
我可以在控制台中激发查询。
and I can fire of queries at the console.
然而，我如何查询和访问我在heroku上的postgres数据库？
However, how can I query and access my postgres database that is up on heroku?
推荐答案
您可以运行 heroku run rails c --app< appname> 。我还会补充一点，如果你想查看你的数据库，你可以使用PG Commander https://eggerapps.at/
You can run heroku run rails c --app <appname>. I will also add, if you want to view your database, you can make use of PG Commander https://eggerapps.at/pgcommander/ which actually automatically parses all the credentials out for you.
如果你想这样做，运行 heroku config - app< appname> ，然后复制 DATABASE_URL 。完成此操作后，在您的PG Commander中创建一个新的收藏夹，您将看到它已经根据剪贴板中的内容自动填充了所有凭据。
If you want to do this, run heroku config --app <appname> and then copy the DATABASE_URL. After you've done this, create a new favourite in your PG Commander and you'll see that it has already automatically filled in all the credentials based on what was in your clipboard.
这篇关于你如何访问你的heroku数据库（特别是postgres）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！