title: Remove external file from postgresql
body: <p>I added a file to postgres using <code>\i /path/to/some/file.sql</code> but there was a typo in the file.  </p>
  
  <p>Here's what I had in the file: </p>
  
  <pre><code>CREATE VIEW holidays AS
    SELECT event_id AS holiday_id, title AS name, starts AS date
    FROM events
    WHERE title LIKE '%Day%' AND venue_id IS NULL;
  </code></pre>
  
  <p>In the original version I had <code>%DAY%</code>.  When running <code>\i /path/to/some/file.sql</code> again, I receive this error:</p>
  
  <pre><code>ERROR:  relation "holidays" already exists
  </code></pre>
  
  <p>How do I undo this relation to get the code to run again?</p>
  
  <p>Thanks</p>