Linux 下使用 PowerShell

安裝

在 Debian Linux 上安裝 PowerShell

設定可連結 postgresql

  apt install powershell apt install -y unixodbc unixodbc-dev odbc-postgresql
  修正 /etc/odbcinst.ini 
  (沒修正執行的時候可能會出現找不到 psqlodbcw.so 八拉巴拉的錯誤訊息)
      Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so

範例程式

建立一個附檔名為 xxx.ps1 的檔案然後內容大致如下。

#!/usr/bin/pwsh

$MyServer = "主機IP"
$MyPort = "資料庫連接Port"
$MyDB = "資料庫名稱"
$MyUid = "使用帳號"
$MyPass = "使用密碼"

#Write-Output "Processing file: 系統測試"

$DBConnectionString = "DRIVER={PostgreSQL Unicode};Server=$MyServer;Port=$MyPort;Database=$MyDB;Uid=$MyUid;Pwd=$MyPass;"
$DBConn = New-Object System.Data.Odbc.OdbcConnection;
$DBConn.ConnectionString = $DBConnectionString;
$DBConn.Open();
$DBCmd = $DBConn.CreateCommand();
$DBCmd.CommandText = @"
    select 
        e.name , u.full_name , u.organization , u.email_address
    from public.guacamole_user u
"@

$reader=$DBCmd.ExecuteReader();

while ($reader.Read()) {
    # 處理每一行數據

    $name = $reader["name"]
    $full_name = $reader["full_name"]
    $name = $reader["organization"]
    $email_address = $reader["email_address"]
    echo "$name`t$full_name`t$name$email_address"
}

$DBConn.Close();