title: postgresql - Schedule Insert data from dblink to a local table In a
body: <p>I am trying to link a remote database to a local database using dblink. What  want to achieve here is: </p>
  
  <ol>
  <li><p>I want to be fetching only data from the latest row(s) every 10 secs from a table in remote  database.</p></li>
  <li><p>I wish to insert the data into a local database into a pre-existing table. In this case, I wish to insert the data I collected from the remote database, plus some others like primary key, and some sequenses which I dont get from the remote database into the table.</p></li>
  </ol>
  
  <p>Any suggestions would be appreciated.</p>