$ErrorActionPreference="Stop"
Set-PSDebug -Strict

# This is the sql server table
#CREATE TABLE dbo.psql_test
#(
#	id INTEGER NOT NULL,
#	varchar_255 VARCHAR(255),
#	date_dt DATETIME,
#	varchar_10 VARCHAR(10),
#	timestamp_dt DATETIME2
#);

Write-Host Started at (Get-Date -Format g)
[System.Boolean]$b = [environment]::Is64BitProcess

if($b) {
Write-Host '64bit PowerShell detected' -ForegroundColor Green
}
else
{
Write-Host '32bit PowerShell detected' -ForegroundColor Green
}
[string] $TableName = "psql_test" 
[System.Data.OleDb.OleDbConnectionStringBuilder]$strBuilder = New-Object System.Data.OleDb.OleDbConnectionStringBuilder -ArgumentList "Provider=sqloledb;Data Source=(local)" 
$strBuilder["Initial Catalog"] = "TEST"
$strBuilder["Integrated Security"] = "SSPI"

[System.Data.OleDb.OleDbConnection]$conn = New-Object System.Data.OleDb.OleDbConnection -ArgumentList $strBuilder.ConnectionString 
[System.Data.OleDb.OleDbDataAdapter]$adapter = New-Object System.Data.OleDb.OleDbDataAdapter -ArgumentList "select id, varchar_255, date_dt, varchar_10, timestamp_dt from dbo.""$TableName"";", $conn
$adapter.MissingSchemaAction = [System.Data.MissingSchemaAction]::AddWithKey
$adapter.MissingMappingAction = [System.Data.MissingMappingAction]::Passthrough
[System.Data.DataSet]$dataSet = New-Object System.Data.DataSet

try
{
    $conn.Open()
    #$adapter.FillSchema($dataSet, [System.Data.SchemaType]::Source, $TableName)
    $adapter.Fill($dataSet, $TableName)
    [System.Data.OleDb.OleDbCommandBuilder]$cmdBldr = New-Object System.Data.OleDb.OleDbCommandBuilder -ArgumentList $adapter

    $dr = $dataSet.Tables[$TableName].NewRow()
    
    $dr["id"] = 1
    $dr["varchar_255"] = "Zxcvbnm"
    $dr["date_dt"] = [System.DateTime]::Parse("01/03/2019")
    $dr["varchar_10"] = "Asdfghjkl"
    $dr["timestamp_dt"] = [System.DateTime]::Now

    $dataSet.Tables[$TableName].Rows.Add($dr)
    Write-Host $dataSet.Tables[$TableName].Rows.Count;

    Write-Host Started Update at (Get-Date -Format g) 
    $adapter.Update($dataSet, $TableName)
    Write-Host Finished Update at (Get-Date -Format g)
#Write-Host $conn.State
}
finally
{
$dataSet.Clear();
$conn.Close()
}