Re: load fom csv

  



  

  
    On Sep 18, 2024, at 6:39 AM, Andy Hartman <hartman60home@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 <hartman60home@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 <robjsargent@gmail.com> wrote:

            
            
              

              

              > On Sep 17, 2024, at 12:25 PM, Adrian Klaver <adrian.klaver@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

              

              >

              >