title: Restore a postgres backup file using the command line?
body: <p>I'm new to postgresql, and locally, I use pgadmin3.  On the remote server, however, I have no such luxury.</p>
  
  <p>I've already created the backup of the database and copied it over, but, is there a way to restore a backup from the command line?  I only see things related to GUI or to pg_dumps, so, if someone can tell me how to go about this, that'd be terrific!</p>