title: How do I insert data into a Postgres table using PowerShell or VBScript?
body: <p>I need to periodically query the event logs on a handful of servers and insert specific events into a Postgres table.</p>
  
  <p>I am having trouble figuring out how I can insert data into a table via ODBC using PowerShell and/or VBScript. I'm reasonably familiar with both VBScript and PowerShell generally, and I can craft a SQL UPDATE statement that works, I'm just trying to tie the two together, which I've never done before.</p>
  
  <p>I have the Postgres ODBC driver installed, I've configured a data source which tests OK.</p>
  
  <p>Google isn't helping me thus far, can someone provide some pointers?</p>