title: Unable to import PostgreSQL database dump - text format dump not accepted
body: <p>Using the pgAdmin4 and attempting to restore a .sql file through the GUI for local use.</p>
  
  <p>I'm presented with the error: <code>pg_restore: [archiver] input file appears to be a text format dump. Please use psql.</code></p>
  
  <p>I'm failing to understand why this is the case when the file has a .sql extension - is there anyway to convert this file to psql as the error message suggests?</p>
  
  <p>The file is viewable here: <a href="https://github.com/datacamp/courses-intro-to-sql/tree/master/datasets" rel="nofollow noreferrer">https://github.com/datacamp/courses-intro-to-sql/tree/master/datasets</a></p>