Re: load fom csv

[Rob Sargent]

On Sep 18, 2024, at 6:39 AM, Andy Hartman <hartman60h...@gmail.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 <hartman60h...@gmail.com> wrote: I'll echo vars and see if something looks strange. THanks. On Tue, Sep 17, 2024 at 3:46 PM Rob Sargent <robjsarg...@gmail.com> wrote: > On Sep 17, 2024, at 12:25 PM, Adrian Klaver <adrian.kla...@aklaver.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 > >