Need to count number of rows of a Postgres table to test it in my Powershell script

Question

I just have a short question. I have a PowerShell script that insert rows into a Postgres table using \copy command. No issue at load, everything goes well.

After the load done, I would like to query the table to count the number of rows inserted and being able to test the value retrieved in my Powershell.

So my problem is to retrieve the result of the Postgres table row count into a PowerShell variable.

I found the below code but even if it does not generates errors it does not return the number of rows in my table.

thanks a lot for your support

$DBCmd             = $DBConn.CreateCommand()
$DBCmd.CommandText = "SELECT COUNT(*) FROM $Load_table_path WHERE audit_trail = '$MyAudit_trail'"     
$rdr               = $DBCmd.ExecuteReader()
$dt                = [System.Data.DataTable]::new()
$dt.Load($rdr)
$dt.Column1
$testtt            = $dt.Column1

Tyler2P · Accepted Answer · 2023-03-26 17:58:40Z

0

Ok, I finally do like this and get the rowcount for the concerned table.

$query = "SELECT COUNT(*) FROM $table_path WHERE audit_trail = '$MyAudit_trail'"

$rowcount_val = psql -t -h $MyServer -U $MyUid -d $MyDB  -p $MyPort -c $query

edited Mar 26, 2023 at 17:58

Tyler2P

2,37030 gold badges26 silver badges34 bronze badges

answered Mar 20, 2023 at 13:40

Locupus

293 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Need to count number of rows of a Postgres table to test it in my Powershell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related