finance_data_process/copy.ps1

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