title: How to update postgreSQL auto incremental field from SAS DI Table Loader
body: <p>I'm new to SAS and PostGreSQL, and I currently working on migrating SAS data to PostGreSQL.
  I have problem when I tried to insert data into PostGreSQL, where there are a auto-incremental column &quot;Id&quot; in the table.
  I using SAS DI, create node SourceTable -&gt; Extract -&gt; Table Loader -&gt; TargetTable.
  I ignore map TagetTable.Id cause this is an auto-incremental column.
  I got error said Id cannot be Null</p>
  <p>Then I tried use NextVal(&quot;Id&quot;) under Id Expression, and I got error &quot;Function NEXTVAL could not be located&quot;</p>
  <p>I tried to set the &quot;Is Nullable&quot; in SAS to true for &quot;Id&quot;, but still get error cannot be Null.</p>
  <p>May I know how can I do this?</p>
  <p>Other than the Id, I also have problem with the timestamp, timestamp should generate by using PostGreSQL...</p>