title: postgresql nextval throws error relation does not exist
body: <p>I have the following sql:</p>
  
  <pre><code> INSERT INTO in_api_settings ( 
     ENTITY_ID, 
     ACTIVE_START_DATE, 
     ACTIVE_END_DATE) 
   VALUES ( 
     nextval('in_api_settings_seq'), 
     current_date, 
     null)
  </code></pre>
  
  <p>And when i execute it i get error </p>
  
  <blockquote>
    <p>ERROR:  relation "in_api_settings_seq" does not exist</p>
  </blockquote>
  
  <p>On Oracle i use IN_API_SETTINGS_SEQ.NEXTVAL and this works fine. I am merging from Oracle to PostgreSQL and not sure what I am doing wrong.</p>