param ( [string]$db_host, [int]$db_port, [string]$db_username, [string]$db_password, [string]$dbname, [string]$table, [string]$filename, [string]$columns ) $env:PGPASSWORD = $db_password $psqlCommand = "psql -h `"$db_host`" -p $db_port -U `"$db_username`" -d `"$dbname`" -c `"\COPY $table ($columns) FROM '$filename' WITH (FORMAT csv, HEADER true, ENCODING 'UTF8');`"" Invoke-Expression $psqlCommand