psql -h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand
I'm wondering if it's waiting on P/w ?
Thanks.
Thanks.
On Tue, Sep 17, 2024 at 7:10 PM Andy Hartman <hartman60home@xxxxxxxxx> wrote:
I'll echo vars and see if something looks strange.
THanks.On Tue, Sep 17, 2024 at 3:46 PM Rob Sargent <robjsargent@xxxxxxxxx> wrote:
> On Sep 17, 2024, at 12:25 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
>
> On 9/17/24 09:21, Andy Hartman wrote:
>> The command work outside of powershell yes
>
> Then you are going to need to use whatever debugging tools PowerShell has available to step through the script to figure out where the problem is.
>
>
Visual Studio can run/debug PS 1 files. I am not at my desk but have done ps1 oneliner queries against mssql
Suggest echoing ALL vars used in psql command
>
>
