title: PostgreSQL: INSERT INTO syntax error
body: <p>I'm following an older tutorial learning Postgres, so it's possible maybe something has changed since it was published. In the tutorial (using psql) I create a table then do some <code>insert</code> statements. Here is the tutorial and corresponding <code>psql</code> commands that cause error:</p>
  
  <p><a href="http://www.postgresqlforbeginners.com/2010/11/create-table-and-constraints.html" rel="nofollow noreferrer">http://www.postgresqlforbeginners.com/2010/11/create-table-and-constraints.html</a></p>
  
  <pre><code>create table people(
     id int PRIMARY KEY,
     name varchar NOT NULL
  );
  insert into people(0,'Steve Jobs');
  insert into people(1,'Mike Markkula');
  insert into people(2,'Mike Scott');
  insert into people(3,'John Sculley');
  insert into people(4,'Michael Spindler');
  insert into people(5,'Gil Amelio');
  insert into people(6,'Mike Scott');
  </code></pre>
  
  <p>I get this error for each insert statement:</p>
  
  <pre><code>ERROR:  syntax error at or near "0"
  LINE 1: insert into people(0,'Steve Jobs');
                             ^
  </code></pre>
  
  <p>I've tried copy pasting, capitalizing the sql commands (ie <code>INSERT</code>), running the command from shell outside of <code>psql</code>, adding spaces, using <code>"</code> instead of <code>'</code> quotes... All result in the same errors. Has something changed or am I possibly doing something wrong?</p>