$SshKey = "C:\Users\Administrator\.ssh\id_rsa_tokyo" $VpsHost = "158.179.179.29" function Invoke-RemoteSql([string]$sql) { $b64 = [Convert]::ToBase64String([Text.Encoding]::UTF8.GetBytes($sql)) $remoteCmd = "echo '$b64' | base64 -d > /tmp/run_query.sql && sudo -u postgres psql -d classnotify -t -A -F '|' -f /tmp/run_query.sql 2>&1 && rm -f /tmp/run_query.sql" $out = ssh -i $SshKey -o StrictHostKeyChecking=no -o ConnectTimeout=15 -o BatchMode=yes root@$VpsHost $remoteCmd if ($out) { return ($out -join "`n").Trim() } return "" } $cols = Invoke-RemoteSql "SELECT column_name FROM information_schema.columns WHERE table_name = 'ActivationCodes';" Write-Host "ActivationCodes columns:" Write-Host $cols