title: Location of postgresql database in nitrous.io project
body: <p>I'm not sure if I'm going mad or if Heroku's dataclips are acting up but I have the following problem.</p>
  
  <p>I've set up a ruby on rails development environment on Nitrous.io and have connected to a database on Heroku. In Nitrous.io I then type <code>psql</code>to access postgresql.</p>
  
  <p>From there I type <code>\l</code>to list the databases.</p>
  
  <p>Then <code>\c &lt;name of development database hosted on heroku&gt;</code></p>
  
  <p>Then <code>\dt</code> to list the relations, one of which is <code>users</code></p>
  
  <p>Finally, I input the command <code>SELECT * FROM users;</code> and this returns relevant information on users such as email address, encrypted password etc etc.</p>
  
  <p>However, when I go to Heroku and create a dataclip with the code <code>select * from users</code>to be run against the same database, I'm getting the following warning </p>
  
  <pre><code>Error: Dataclip cannot be created
  ERROR:  relation "users" does not exist
  LINE 2: select * from users
  </code></pre>
  
  <p>Am I completely missing something here or is the dataclip throwing an error for no reason? I'm using Devise (for the first time) in my app. Would this have anything to do with it?</p>
  
  <p><strong>Edit</strong></p>
  
  <p>I'm starting to think I've stored the database on Nitrous.io and not in Heroku. I think I may have used autoparts to install postgresql on my nitrous.io vm</p>
  
  <p>I've run the command <code>SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'</code> as a dataclip on Heroku and the users table just isn't there. I then ran it on some other projects I have on Heroku and I can clearly see the tables I've created. </p>
  
  <p>Can anyone confirm my suspicion or know how I can check the location of the database? </p>