Postgres Pro
Downloads
Home   >   mailing lists

Re: load fom csv - Mailing list pgsql-general

From Andy Hartman
Subject Re: load fom csv
Date
Msg-id CAEZv3cp2hTWDXjbfGt2uTWb=j5FoS0DpbdzzQwTO2QKuxzZrPg@mail.gmail.com
Whole thread Raw
In response to Re: load fom csv  (Andy Hartman <hartman60home@gmail.com>)
List pgsql-general
Tree view
psql -h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand 

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

Thanks.

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

>
>

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: IO related waits
Next
From: Christophe Pettus
Date:
Subject: Re: CREATE DATABASE command concurrency