title: postgresql cannot insert from table Cannot insert
body: <p>I am working on a PostgreSQL table that takes data from one table and inserts it into another.</p>
  
  <p>i created a table:</p>
  
  <pre><code>create table temp_appearance (firstname text, lastname text, position text, media text);
  </code></pre>
  
  <p>and populated it with data.</p>
  
  <p>I then created a new table:</p>
  
  <pre><code>create table actors (id serial primary key ,firstname text, lastname text, position text);
  </code></pre>
  
  <p>But when I insert into actors from temp_appearance:</p>
  
  <pre><code> insert into actors (firstname, lastname, position) 
   select firstname, lastname, position from temp_appearance;
  </code></pre>
  
  <p>it gives me this error:
  ERROR: COLUMN "firstname" does not exist
  HINT: There is a column named "firstname" in table "actors", but it cannot be referenced from this part of the query.</p>
  
  <p>I cant figure out why it is donig this since these same commands have worked on postgreSQL on other computers. 
  Thanks!</p>