Re: load fom csv

On Sep 18, 2024, at 6:39 AM, Andy Hartman <hartman60home(at)gmail(dot)com> wrote:




psql -h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand 

I'm wondering if it's waiting on P/w ?

Thanks.

Very likely.  Can you show the authentication 

mechanisms used (pg_hba)?

On Tue, Sep 17, 2024 at 7:10 PM Andy Hartman <hartman60home(at)gmail(dot)com> wrote:

I'll echo vars and see if something looks strange.

THanks.

On Tue, Sep 17, 2024 at 3:46 PM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:

> On Sep 17, 2024, at 12:25 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> 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

>

>