title: PostgreSQL insert query
body: <p>I try to insert a single line to log table, but it throws an error message . >&lt;</p>
  
  <p>The <code>log</code> table structure is like this:</p>
  
  <pre><code>no         integer  NOT NULL nextval('log_no_seq'::regclass)    
  ip         character varying(50)    
  country    character varying(10)    
  region     character varying(10)    
  city       character varying(50)    
  postalCode character varying(10)    
  taken      numeric  
  date       date
  </code></pre>
  
  <p>and my query: </p>
  
  <pre><code>INSERT INTO log (ip,country,region,city,postalCode,taken,date) VALUES 
  ("24.24.24.24","US","NY","Binghamton","11111",1,"2011-11-09")
  </code></pre>
  
  <p><code>=&gt; ERROR:  column "postalcode" of relation "log" does not exist</code></p>
  
  <p>second try query :  (without postalcode)</p>
  
  <pre><code>INSERT INTO log (ip,country,region,city,taken,date) VALUES 
  ("24.24.24.24","US","NY","11111",1,"2011-11-09")
  </code></pre>
  
  <p><code>=&gt; ERROR:  column "24.24.24.24" does not exist</code></p>
  
  <p>I don't know what I did wrong...</p>
  
  <p>And PostgreSQL does not have datetime type? (2011-11-09 11:00:10)</p>