How to view current database schema for Heroku app in Terminal?
You could run heroku pg:psql
to fire up a Postgres console, then issue \d
to see all tables, and \d tablename
to see details for a particular table.
For a rails schema, try:
$ heroku run "bundle exec rake db:schema:dump && cat db/schema.rb"